| title | Connect to Any SQL Server Component | ||||
|---|---|---|---|---|---|
| description | Connect to Any SQL Server Component from SQL Server Management Studio | ||||
| ms.prod | sql | ||||
| ms.prod_service | sql-tools | ||||
| ms.technology | ssms | ||||
| ms.topic | ui-reference | ||||
| helpviewer_keywords |
|
||||
| author | markingmyname | ||||
| ms.author | maghan | ||||
| ms.reviewer | |||||
| ms.custom | seo-lt-2019 | ||||
| ms.date | 01/19/2017 |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
SQL Server Management Studio provides functionality for managing every component of [!INCLUDEssNoVersion]. Use Management Studioto connect to:
-
An instance of the [!INCLUDEssDEnoversion].
-
[!INCLUDEssASnoversion].
-
[!INCLUDEssISnoversion].
-
[!INCLUDEssRSnoversion].
Although Management Studio allows you to work with queries without first establishing a connection to a data source, most other tasks require a connection. Management Studioprovides the Connect to Server dialog box to configure connection properties to [!INCLUDEssNoVersion] components. When Management Studiostarts, it opens the Connect to Server dialog box and prompts you to connect to a server. The Connect to Server dialog box retains the connection settings from the last time it was used.
Note
This feature can be turned off so no connection is automatically initiated. For more information, see Database Engine Service Startup Options.
You can save connections to specific servers in Registered Servers, or you can save connections in projects with Solution Explorer.
When you register a server, Management Studio saves the connection information in Registered Servers. To connect to a registered server, double-select the server name in Registered Servers. Object Explorer then opens a connection to the server.
Solution Explorer allows you to store related queries, scripts, connections, and other associated information in a project. Each script project contains a node called Connections, where you can save one or more connections. To add a connection, right-click Connections, and then select New Connection. To access a saved connection, expand Connections and double-select the connection Management Studio opens a query window associated with that connection. When saved, scripts retain their association to a specific connection.