For a long time now I am stuck with a saved user in SQL Server 2008 that I just didn’t want to use:
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):
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