26

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.

Tom H
  • 46,766
  • 14
  • 87
  • 128
larryr
  • 1,536
  • 3
  • 17
  • 27

3 Answers3

37

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.

Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
Tom H
  • 46,766
  • 14
  • 87
  • 128
  • 3
    you should mention that the studio version \100\ might change according other versions (not asked, i know) – Bernhard Apr 06 '17 at 08:19
  • This answers applies only to the SSMS that was included in SQL Server (up to 2014). See the other answer for SSMS v17 and v18. – Razvan Socol Jan 29 '20 at 05:49
14

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
gtrianda
  • 141
  • 1
  • 6
1

In windows 8 and 7 here is the correct path.

C:\Users\username\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml
Kai
  • 38,985
  • 14
  • 88
  • 103
Aaron
  • 47
  • 1
  • 1
    Nope, the accepted answer is missing the roaming folder and this answer specifies that ;) – Maarten Kieft Feb 26 '13 at 08:24
  • 12
    No, the accepted answer correctly says %APPDATA% which IS the correct macro for the roaming folder. Your answer incorrectly assumes that your Roaming folder is in C:\Users\username\AppData\Roaming\, which it won't necessarily be. – NickG Aug 07 '13 at 16:46