How to access "SQL Server Management Studio" (SSMS)
In the previous article, you learned how to download and install SQL Server Management Studio (SSMS).
Related: How to download and install SQL serverAfter successfully installing SSMS, you can see the symbol of SSMS as below...
You can access, manage, update, administer, configure, and work on the data using SSMS.
As soon as you click on the SSMS, you can see the "Connect to Server" screen.
Before going ahead, let's learn the meaning of the above terms.
1. Server type: In SQL, you can see different Server type options like Database Engine, Analysis Sevices, Reporting Services, Integration Services, and Azure. But we will use the Database Engine to do all the tasks noted above.
2. Server name: This is the SQL Server name where you installed the MS SQL server. You need to establish the connection to go ahead with SSMS.
3. Authentication: You can Authenticate via Windows and SQL Server. If you have selected the default Authentication then use "Windows Authentication". If you want to secure data, you can also set up a login and Password. I will show how to generate a login id and password in the next article.
Related: How to Download & Install Microsoft SQL Server Management Studio (SSMS)User name and Password is not required if you selected "Windows Authentication".
Then Click on "Connect". You can see the screen given below, You will be connected to " SSMS".
Written by: Kalpesh Agrawal (Actuarial Intern- IIB)