![sql server management studio icon sql server management studio icon](https://blog.sqlauthority.com/wp-content/uploads/2016/12/systemversioned-800x435.jpg)
![sql server management studio icon sql server management studio icon](https://docs.microsoft.com/en-us/sql/ssms/tutorials/media/ssms-configuration/objectexplorer.png)
Once your server is connected, the Object Explorer will display all relevant information to that connection.
#SQL SERVER MANAGEMENT STUDIO ICON WINDOWS#
For now, let’s stick to your local server installation and Windows authentication. We’ll do this later when we set up your Azure server. However, if you’re connecting to an online or network server, you’ll most likely want to select SQL Server Authentication from the dropdown. Then click Connect, and your server connection will be established. For local installs, it will most likely be Windows Authentication, which will default to your Windows login username. Alternatively, you can type in (or paste) the name of the server to which you wish to connect, such as the one in the connection string for your application: SQL Server - connect to server with server name suppliedĪt this point, you may change the authentication type if necessary. However, if nothing appears here, or you need to connect to a different server, you may click. You can select one of these if that is what you desire. You’ll see all of the SQL Server instances of which your SSMS installation is aware.
![sql server management studio icon sql server management studio icon](https://amitelman.files.wordpress.com/2014/10/clipboard03.jpg)
To select a server for the connection, click the Server name dropdown, as shown below. This window can also be brought up by clicking the Connect dropdown in the Object Explorer window and selecting Database Engine: Access the connection window within SSMS When you launch SSMS, you will see the SQL Server connection window: SQL Server - connect to server You may have completed this during the SSMS install, but in case you skipped over it, we’ll go through adding a server to your SQL Server installation via SSMS now. So get that done, and then let’s get busy connecting to your local server. If you haven’t installed SSMS yet, then now is the time to do it, because you’ll need it the rest of the way. You’ve seen SQL Server Management Studio before, but you probably haven’t had an opportunity to learn how it can help you build, maintain, and manage your relational databases.