Export (0) Print
Expand All
3 out of 4 rated this helpful - Rate this topic

Registering Servers

Registering a server in SQL Server Management Studio allows you to store the server connection information for future connections. When you register a server, you must specify:

  • The type of server. In Microsoft SQL Server, you can register the following types of servers: SQL Server Database Engine, Analysis Services, Reporting Services, Integration Services, and SQL Server 2005 Compact Edition.
  • The name of the server.
  • The type of authentication used to log on to the server.
ms190631.security(en-US,SQL.90).gifSecurity Note:
When possible, use Windows Authentication.. For maximum security when using SQL Server Authentication, you should select to prompt for the login name and password when possible.

  • Your user name and password, if appropriate.
    ms190631.note(en-US,SQL.90).gifNote:
    The exact information required depends on the method of authentication. For example, if you are registering a report server and choose Internet authentication, you must supply your e-mail address and password, rather than the user name and password.

  • The name of the group where you want the server to be listed after it is registered.
  • The registered server name. The default is the name of the server, but it can be overridden with a more meaningful name. For example, a server named TSAKK32440 can be registered with the name of the frequently accessed database such as Northwest Sales.

You can also select connection properties for the server you are registering. You can specify the following connection options:

  • The database you want the server to connect to by default.
  • The network protocol to use when connecting to the server.
  • The default network packet size to use.
  • The connection timeout.
  • The execution timeout.
  • The time to wait before disconnecting an idle connection.

There are three ways to register a server in SQL Server Management Studio. Local instances of SQL Server are automatically registered during the first launch of Management Studio after its installation. You can also initiate the automatic registration process at any time, to restore the registration of local server instances. Lastly, you can register a server using the Registered Servers tool of SQL Server Management Studio.

To… See…

Automatically register local server instances

How to: Register a Connected Server (SQL Server Management Studio)

Register a server

How to: Register a Connected Server (SQL Server Management Studio)

Add view registered servers

How to: View Registered Servers in SQL Server Management Studio

Remove a registered server

How to: Remove a Registered Server (SQL Server Management Studio)

To change a server's registration

How to: Change a Server's Registration (SQL Server Management Studio)

To connect to a registered server

How to: Connect to a Registered Server (SQL Server Management Studio)

Disconnect from a registered server

How to: Disconnect from a Registered Server (SQL Server Management Studio)

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.