Import Registered Servers

Use this dialog box to import registered server information.

To open this dialog box, in Registered Servers, right-click Local Server Groups or any subfolder, select Tasks, and then click Import.

Note

You cannot import registered server information into SQL Server 2008 from earlier versions of SQL Server.

Why Import Registered Servers?

Exporting and then importing registered server files lets you easily configure several computers with the same servers in Registered Servers. This is useful when managing a large number of servers from computers in several locations, or when you want to configure basic connection settings for a less-experienced user.

Note

Server registrations that use SQL Server Authentication store passwords on a per-user basis. After importing the server registrations, users must enter the password for each server the first time they connect, storing the passwords in their lists of registered servers. This is not necessary for servers registered through Windows Authentication.

  • Import file
    Type the name of the import file in the text box, or click the Browse button (...) to locate the import file on the client computer. If you select an existing file, the registered server information is appended to the file. The import file can only be a previously exported registered server file. Registered server files have a .regsrvr extension.

  • Select the server group to import to
    Select the root node or a particular server group to which the registered server entries in the file will be imported. You can import all registered servers, registered servers in a particular server group, or a single registered server to the export file. The import functionality is recursive; for example, if server group A contains server group B, and server group B contains server groups C and D, importing server group A exports all entries in A, B, C, and D.

    The server group displays only the server groups of the current registered server tree.

    Note

    If you select to import an existing server group or server, a message confirms that you want to overwrite the existing server or server group.

See Also

Concepts