Registering a Server

In the SQL Server Management Studio you can register the SQL Server to have faster access to it. To register a server you need to specify the:

• Name of the server
• Security used to log on to the server
• Name of the group where the server is to be installed

Procedure

1. In the SQL Server Management Studio, choose View → Registered Servers.
2. The Registered Servers section appears.
3. Right-click on one of the defined Server Groups and choose New Server Registration.
4. In the text field Server name, enter the name of the server.
5. Enter the Registered Server name (see name in list)
6. Select Windows authentication to specify the type of authentication the SQL Server Management Studio uses to connect to the server.
7. Select any further options that you might require.
8. Confirm your entries with OK.

   The SQL Server is now registered and appears in the SQL Server Management Studio under the Registered Servers section.

   Note

   If you later want to change the options you have selected, simply right-click the server in the Registered Servers section and choose Properties.

   The Edit Server Registration Properties dialog box opens and you can edit the options as required.