Export (0) Print
Expand All

Register a Connected Server (SQL Server Management Studio)

This topic describes how to register servers in SQL Server 2014 by using SQL Server Management Studio. By registering the server, you can save the connection information for servers that you access frequently. A server can be registered before connecting, or at the time of connection from Object Explorer.

In This Topic

To register a connected server

  • In Object Explorer, right-click a server to which you already are connected, and then click Register.

    Server name

    Enter the name you want to use for the registered server. Registering a local or remote server using SQL Server Management Studio lets you store the server connection information for future connections. This field defaults to the server name entered when you were connecting to the server. You can retain this server name or enter another easy-to-use name for the server.

    Server description

    Enter an optional description of the server. The maximum number of characters allowed is 250.

    Select a server group

    Select the server group where you want to save the server registration.

    New Group

    Click to launch the New Group dialog box, where you can create a new server group for the registered server.

    Save

    Click to save the information you have entered and create a registered server.

Arrow icon used with Back to Top link [Top]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft