Import Registered Server Information (SQL Server Management Studio)
This topic describes how to import saved registered server information in SQL Server 2016. 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.
You cannot import registered server information into SQL Server 2016 from earlier versions of SQL Server.
To import registered server information
In Registered Servers, click the server type on the Registered Servers toolbar. The server type must be the same as the registered server export file type. For example, if you have exported SQL Server registered server information, you must click SQL Server on the Registered Servers toolbar.
Right-click a server group, and select Import.
In the Import Registered Servers dialog box, select the registered servers file to import, and then click OK.
- 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.
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.
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.