Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

When I launch SQL Server Management Studio, most of the time it remembers the login & password, but from time to time, I have to retype the password.

Is this something that happens periodically for security, or is it a bug, or is it something that I'm doing?

share|improve this question
    
Since I don't have the rep to edit your question: It's "lose", not "loose". Can you please fix it for me and all the other pedants? :) –  Matt Hamilton May 4 '09 at 9:26
    
@Matt Hamilton: This particular misspelling is something that troubles me as well. It seems to affect non-native speakers mainly. It it is spoken as "loose" after all (just like "goose"), while "lose" would have to be pronounced like "hose", naturally. :) –  Tomalak May 4 '09 at 9:40
    
Corrected the spelling. For information, I am a native speaker, AND a bad typist :-) –  Matthew Farwell May 4 '09 at 14:30

1 Answer 1

up vote 3 down vote accepted

This is a bug with SQL Management Studio. Microsoft seem to be aware of it, but have not fixed it as yet, and many users are experiencing it. Some users have reported success with always running the app as an administrator on Vista or Windows 7.

You can run Managment studio from the command line, and supply your password in this. By creating a shortut to this command it would always remember it, but obviously you would be hardcoding the password in there, not very secure. If you wanted to do thisthe command is:

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\
SqlWb.exe" /S yourserver -U youruser -P yourpassword"
share|improve this answer
    
I have been experiencing this since I installed SP2 on a SQL Server 2005 instance ;-) Thanks for the solution! –  MarlonRibunal May 4 '09 at 21:09

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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