How to copy SSMS connections in dropdown to a new computer?

Question

I'm getting an upgraded laptop at work and my old machine had SSMS 17.9 with several dozen dbengine connections with pwds in the dropdown for dbengine Connection.

Are these in the registry, ini file, Windows Credential manager? I would like to be able to copy them to the new machine. I'm even ok if I have to re-enter the passwords--the servernames are really a bigger deal to me. Thanks,

score 1 · Answer 1 · answered Sep 10 '19 at 15:33

In your source SSMS, in Registered Servers: right-click the server group that contains your connections > Tasks > Export...
Copy the exported file to the machine that contains the new SSMS instance.
On the new instance of SSMS, in Registered Servers: right-click the server group that will contain your connections > Tasks > Import...

score 1 · Accepted Answer · answered Sep 10 '19 at 15:35

1

Export the registered servers.

answered Sep 10 '19 at 15:35

Ricardo C

2,205
20
24

Thanks, that did it! – jimo3 Sep 10 '19 at 16:00

score 0 · Answer 3 · answered Nov 24 '21 at 15:22

0

You can copy from the old computer to the new one from the following path: %userprofile%\AppData\Roaming\Microsoft\Microsoft SQL Server\18.0\UserSettings.xml

(18.0 its the SSMS version, it may vary from each specific case)

answered Nov 24 '21 at 15:22

Ivan-San

771
1
5
22

How to copy SSMS connections in dropdown to a new computer?

3 Answers3