I'm using SMS 2008 & I'm looking for where the registered servers are stored on my local machine. I have searched the registry with no luck.
By default, Registered Servers appears above Object Explorer in the main window.
"Registered Servers" is the overarching name for three different types of repositories that store server connection information and enable multi-server queries. dbatools supports all three types of repositories. Local Server Groups. Azure Data Studio.
To create a new registered server. If Registered Servers is not visible in SQL Server Management Studio, on the View menu, click Registered Servers. When a server is registered from Registered Servers, the Server type box is read-only, and matches the type of server displayed in the Registered Servers pane.
They are kept as an XML document here:
%APPDATA%\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml
On Windows XP this resolves to:
C:\Documents and Settings\username\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml
Note: As of Windows Vista there is no Application Data folder, and the path resolves differently.
For Windows 10 and SSMS version V17 the document can be found using this path in windows explorer
%APPDATA%\Microsoft\SQL Server Management Studio
Or this powershell command
dir "$env:APPDATA\Microsoft\SQL Server Management Studio\RegSrvr.xml" Example Directory: C:\Users\george\AppData\Roaming\Microsoft\SQL Server Management Studio Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 19/02/2019 4:04 PM 60998 RegSrvr.xml
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With