Install SQL Server Express and SQL Server Management Studio

Filed Under: SQL Server

SQL server is one of the most used databases in the world. Also, SQL server’s performance is well known to the world. In order to understand any system the best way is to try out the system.

We will also do the same. Let us install SQL Server into our Windows system.

Install SQL Server Express

  1. Click on the link below to download SQL Server.

    SQL Server download

  2. The link will take you to the SQL Server download page.
    SQL Server Download Options

    SQL Server Download Options

    You will get the above two options for download.

  3. We will be downloading Express edition as that has most of the components that we need to development purpose.
  4. Click on the Download now button. The following file will get downloaded.
  5. SQL Server executable file

    SQL Server executable file

  6. Double click on the downloaded executable file and the following screen will appear.
  7. SQL Server installation options

    SQL Server installation options

    We will select Basic for the purpose of this installation guide as it provides the default configuration options. You can select any one of the three options based on your need. Click on Basic.

  8. SQL server installation license term screen will appear as shown below. Click on Accept.
  9. SQL Server installation license terms

    SQL Server installation license terms

  10. The necessary files will get auto downloaded and the installation process will be in progress.
  11. SQL Server Installation In Progress

    SQL Server Installation In Progress

  12. Post successful completion of the process. The following screen will appear.
  13. SQL Server Successful installation

    SQL Server Successful installation

  14. After successful installation, you can click Connect Now to connect to the DB and get started.

Now that we have successfully installed SQL Server Express edition. We will need a UI to connect to the DB and run queries.

We will use SQL Server Management Studio for this purpose.

Install SQL Server Management Studio

SQL Server Management Studio is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.

SSMS provides tools to configure, monitor, and administer instances of SQL. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.

Use SQL Server Management Studio (SSMS) to query, design, and manage your databases and data warehouses.

Let us start with the installation of SSMS to understand it better.

  1. Click on the link below for downloading SQL Server Management Studio
  2. Download SQL Server Management Studio

  3. Click on the first link if you are downloading SQL Server Management Studio for the first time and if you already have a 17.x version and want to upgrade to the latest version please click on the second link.
  4. SQL Server Management Studio Download Link

    SQL Server Management Studio Download Link

  5. The following executable file will get downloaded. Double Click on the file.
  6. SSMS Setup File

    SSMS Setup File

  7. On double-clicking the file. The following screen will appear. Click on Install button.
  8. SSMS Installation Screen

    SSMS Installation Screen

  9. After Clicking on Install, the installation procedure will start automatically.
  10. SSMS Installation loading package

    SSMS Installation loading package

  11. Once the installation is complete following screen will appear.
  12. SSMS Installation complete

    SSMS Installation complete

  13. Launch SSMS and Authentication screen will appear. There are various ways to log in. You can select the option based on which you have configured for authentication.
  14. SSMS Authentication

    SSMS Authentication

  15. Click on Connect and the following screen will appear on the left side of the window.
  16. SSMS Explorer

    SSMS Explorer

Congratulation You have successfully installed SQL Server Express and SQL Server Management Studio.

Leave a Reply

Your email address will not be published. Required fields are marked *

close
Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages