MS SQL Server and SSMS on Windows

This is a step-by-step guide for installing MS SQL Server 2019 (latest at the time of writing this document) and SSMS 18.9.2 for Windows OS.

Refer to the Prerequisite section before you proceed.

Download MS SQL Server for Windows

Click here to go to the SQL Server Downloads link. Scroll down and choose between the Developer edition or Express edition. Download

This guide uses the Developer edition for development and testing in a non-production environment.

Install MS SQL Server

  1. Click on the Download now button for the Developer edition.
  2. Next, double click SQL2019-SSEI-Dev from your installed location to start the installer. SQL2019-developer-setup
  3. Select the recommended Basic installation type. Developer basic edition
  4. Click Accept to accept the License Agreement. Accept License
  5. You can select the default install location or change the location by clicking on the Browse button. Installation directory Click Install.
  6. On the installation complete screen, you may want to note the following information: Instance name, connection string, log folder path, SQL engine path, and the installation resources folder path.

Install SSMS

Install SSMS

  1. On the SQL Server 2019 completion screen, click Install SSMS.
  2. On the download page, scroll down and click on Download SQL Server Management Studio (SSMS). Download SSMS
  3. Double click the SSMS-Setup-ENU.exe executable from your download location. SSMS setup
  4. The default download location is indicated. To select a different location, click the Change button. Install SSMS Click Install.

Once SSMS is successfully installed, click Restart. SSMS Installed

Congratulations! You have successfully installed MS SQL Server 2019 and SQL Server Management Studio (SSMS) 18.9.2 on Windows.

Connect to SQL Server Database Engine

  1. Click Start and search Microsoft SQL Server Management Studio or SSMS.

  2. From the Object Explorer panel on the left, click Connect.

  3. In the Connect to Server dialog box, click Connect with the default server values. In this case, Server name is your machine name.

  4. You are now connected to MS SQL system database as indicated with a green arrow in the screenshot. Connected to DB engine

Next Steps

Create a database, create table(s), and issue T-SQL commands on the SQL database.

Did you find this page helpful?
Start with GraphQL on Hasura for Free
  • ArrowBuild apps and APIs 10x faster
  • ArrowBuilt-in authorization and caching
  • Arrow8x more performant than hand-rolled APIs
Promo
footer illustration
Brand logo
© 2024 Hasura Inc. All rights reserved
Github
Titter
Discord
Facebook
Instagram
Youtube
Linkedin