How are SQL server management studio passwords saved?
5,089
It probably uses a technology called DPAPI. There's some info about it at http://msdn.microsoft.com/en-us/library/ms995355.aspx. Basically encryption is based on the login password but they keys can also be backed up. In a domain environment, automatic backup is probably enabled - relying on a very secure & trusted domain controller.
Related videos on Youtube
05 : 51
How to Enable Sql server Authentication in Sql server 2017 || Create a new User in Sql server 2017
07 : 45
Set SQL server password
03 : 28
Reset SA password in SQL Server
01 : 20
How are SQL server management studio passwords saved?
02 : 09
SQL Server Management Studio Saved Password
Author by
Alex KeySmith
A versatile full-stack developer currently specialising in data, based in the UK with over 13 years of experience. #SOreadytohelp Want to learn more, find me on LinkedIn
Updated on September 17, 2022Comments
-
Alex KeySmith almost 2 years
If, when connecting to a database with sql server management studio and you select "remember password"... where and how is it saved?
I presume it is somehow encrypted using your windows login password?
-
Joe_Rose almost 14 yearsWhat version of windows, what version of SQL Studio?
-
Alex KeySmith over 13 yearsHi JNK, It's XP SP3 and SSMS 2005
-
