Export Registered Servers
Use this dialog box to export registered server information.
To open this dialog box, in Registered Servers, right-click Microsoft SQL Servers and then click Export.
Why Export 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 a less experienced user with basic connection settings.
Note
Server registrations that use SQL Server Authentication store passwords on a per-user basis. After exporting and 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 using Windows Authentication.
Server group
Specify the server group which will be exported. Export all registered servers, registered servers in a particular server group, or a single registered server to the export file. The export functionality is recursive; for example, if server group A contains server group B, and server group B contains server groups C and D, exporting 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.
- Export file
Type the name of the export file in the text box or use the Browse button (...) to locate an export file on the client computer. If you select an existing file, the registered server information is appended to the file. Use the .regsrvr extension.
Do not include user names and passwords in the export file
Exclude user names when exporting the file.Important
Although the export files are encrypted, if user names and SQL Server Authentication passwords are included in the file, access to the file should be carefully controlled. User names and passwords are therefore excluded from the export file by default.