Available Databases: This drop-down list will display all the databases that are available on this server.New Query: If we want to write a Query against any database, then you have to click this New Query.
It will ask the user to enter the Username and Password to connect with the server.
And refer to Install SQL Management Studio to follow the steps involved in installing SQL Server Management Studio only. TIP: Please refer to Install SQL Server to understand the steps involved in installing SQL Server completely. Once you click on the SQL Management Studio, a new window called Connect to Server will open. To open or Start the SSMS, type SQL Server Management Studio on the start page, or open the Run dialog box and type SSMS.exeĪlternatively, you can navigate yourself to C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2014 for 64 bit, and C:\ProgramData(x86)\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2014 for 32-bit and click the application.
How to start SQL Server Management Studio? In this section, we will cover most of the options that are available in this SQL management studio tool.
The SQL Server Management Studio is not the actual server, but it provides an opportunity to connect and work with SQL elegantly. The Microsoft SQL Server Management Studio, shortly called as SSMS is a Flexible and most powerful tool to work with SQL Server.