| title | Connect to Any SQL Server Component | ||||
|---|---|---|---|---|---|
| ms.custom | seo-lt-2019 | ||||
| ms.date | 01/19/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | sql-tools | ||||
| ms.reviewer | |||||
| ms.technology | ssms | ||||
| ms.topic | conceptual | ||||
| helpviewer_keywords |
|
||||
| ms.assetid | 5eeb41bd-b25b-4d3b-a005-a7d9e4b5978e | ||||
| author | markingmyname | ||||
| ms.author | maghan |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] [!INCLUDEssManStudioFull] provides functionality for managing every component of [!INCLUDEssNoVersion]. Use [!INCLUDEssManStudio] to connect to:
-
An instance of the [!INCLUDEssDEnoversion].
-
[!INCLUDEssASnoversion].
-
[!INCLUDEssISnoversion].
-
[!INCLUDEssRSnoversion].
Although [!INCLUDEssManStudio] allows you to work with queries without first establishing a connection to a data source, most other tasks require a connection. [!INCLUDEssManStudio] provides the Connect to Server dialog box to configure connection properties to [!INCLUDEssNoVersion] components. When [!INCLUDEssManStudio] starts, 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, [!INCLUDEssManStudio] saves the connection information in Registered Servers. To connect to a registered server, double-click 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 click New Connection. To access a saved connection, expand Connections and double-click the connection. [!INCLUDEssManStudio] opens a query window associated with that connection. When saved, scripts retain their association to a specific connection.