How to Install SQL Server Management Studio | GreaterHeight Academy Training

How to Install SQL Server Management Studio 20.

In this tutorial, you will learn how to install SQL Server on a Windows operating system with a brief introduction to SQL in general

Introduction to SQL Server Management Studio 20

SQL Server Management Studio (SSMS) 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 Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications and build queries and scripts.

Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer or in the cloud.

For customers needing a cross-platform companion to SSMS for managing SQL and other Azure databases, use Azure Data Studio.

Installing SQL Management Studio 20. on Windows

1. Go to the Download SQL Server Management Studio.

2. Click the link that says Free Download for SQL Server Management Studio (SSMS) (it should be under the Download SSMS heading).

3. Open the downloaded file. How you do that depends on the web browser you use but it’s usually in the Downloads panel. Here’s how it may look:.

4. If asked to allow this app to make changes to your device, click Yes.

5. If it says the computer needs to be restarted before setup can continue:

A. Click Restart.

B. Once your computer has restarted, you may be able to go into the Downloads folder and launch the SSMS-Setup-ENU.exe file, or go back to the Download SQL Server Management Studio page and again click the link that says Free Download for SQL Server Management Studio (SSMS).

C. Once the file has re-downloaded, open it.

6. You should now see the install screen for Microsoft SQL Server Management Studio with Azure Data Studio:

4. Click Install.

8. If asked to allow this app to make changes to your device, click Yes.

9. Once the installation is complete, you should see a file named SSMS-Setup-ENU in your downloaded folder. Double click on that file and select Yes. Then click on Install, it will take some time for it to complete again depending upon your internet connection. You might be asked to restart your system for the installation to complete. Once the setup is complete, click on close.

Launch the SQL Server Management Studio App

1. Finally, you can close the SQL server installation center. Go to windows start and search for Microsoft SQL Server Management Studio, and you should be able to find it, once you open it the UI should look similar to one shown below:

2. It will show you a connect to server option with multiple parameters like Server Type, Server Name, Authentication, etc. Click on server name and select browse for more in that select Database engine. Once you select Database Engine it would show you the instance name you had created in instance configuration, click ok.

3. Then in the Authentication, select SQL Server authentication. It's important to note that the login will be default name i.e., sa, and the password will be the same as you had created in the earlier steps.

4. As a final step, just click on Connect. Once connected, you should see the Datacamp_SQL server that you had created listed on the object explorer panel, which means that you have successfully established a connection with your local SQL server. And you are all set to create a database, add, delete and insert in it.

Conclusion
Congratulations on finishing the tutorial.

This tutorial should take you one step closer to learning SQL in a more practical sense since your environment is set up now.

Please feel free to ask any questions related to this tutorial in the comments section below.

If you would like to learn about SQL from basic to an advanced level, take GreaterHeight Academy's Master SQL Server Development skill track.

Contact Us

Please click the setting button to choose the source of the form.

TOP TRENDING COURSES

PEOPLE ALSO BOUGHT

App site | Recent post | Comments

How to Install SQL Server Management Studio 20.

Installing SQL Management Studio 20. on Windows

Conclusion

COMPANY

QUICK LINKS

SECURE PAYMENTS

Contact Us

TOP TRENDING COURSES

PEOPLE ALSO BOUGHT