Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
    
What version of windows, what version of SQL Studio? – JNK Sep 15 '10 at 14:23
    
Hi JNK, It's XP SP3 and SSMS 2005 – Alex KeySmith Nov 23 '10 at 14:27
up vote 1 down vote accepted

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .