Subscribe Now: Feed Icon

Saturday, March 3, 2012

SQL Server 2008: Forget a user/password

For a long time now I am stuck with a saved user in SQL Server 2008 that I just didn’t want to use:

image

Once upon a time I used that user (that has almost no permissions) for just one action – unfortunately I checked the “Remember password” and whenever I choose that server in the servers combo box I got that damn user. Well I finally had enough!

So I Googled “remove sql server 2008 user password Remember password” and found this StackOverFlow post.

The solution is fairly easy, just rename: C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin to SqlStudio.bin0 (as a rule I never delete a file I don’t have a backup to). And now SQL Server doesn’t remember anything (not even the servers I was on):

image

But that is just a hundred times better than the previous headache…

 

Resources:

StackOverFlow: Removing the remembered login and password list in SQL Management Studio