Connect to any SQL Server component from SQL Server Management Studio

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

SQL Server Management Studio provides functionality for managing every component of SQL Server. Use Management Studioto connect to:

  • An instance of the SQL Server Database Engine.

  • Analysis Services.

  • Integration Services.

  • Reporting Services.

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 SQL Server 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.

Save connections

You can save connections to specific servers in Registered Servers, or you can save connections in projects with Solution Explorer.

Save connections in Registered Servers

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.

Save connections in Solution Explorer

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.

See also