Import Registered Server Information (SQL Server Management Studio)
This topic describes how to import saved registered server information in SQL Server 2014. 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 2014 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.
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.