4

I've been using SQL Server Management Studio 2012 for a while (on Windows 10, if that matters) and I've collected a good bunch of saved logins.

I've now installed version 17.2, which apparently installs side by side (rather than replacing previous version), and my logins are not available in this version.

Is there a way to migrate them from 2012?

3

All cached logins are saved on %APPDATA%\Microsoft\SQL Server Management Studio\%Version%\SqlStudio.bin

Each time you run SSMS and save a login, it is added to SqlStudio.bin file. Now i assume your new SSMS has no saved logins, therefore simply replace SqlStudio.bin with the one from old SSMS

Steps:

Go to: %APPDATA%\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin , copy that file and then go to %APPDATA%\Microsoft\SQL Server Management Studio\14.0 and replace the existing one.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.