SQL 2008 rejects correct password when logging in to Management Studio

Hi everyone,

I have a strange problem that's slowing me down a bit here...

Whenever I connect to a particular server in Management Studio 2008, I use SQL authentication. I can type the password manually and it is accepted. However, whenever I choose "Remember password" it stops working. I am able to log in that time, (i.e. while it's saving the password) but any subsequent times when it is retrieving the saved password to log me in, it fails with:

Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)

Does anyone have any solution to this?

Server: SQL Server - 10.50.1600
App: Microsoft SQL Server Management Studio - 10.0.2531.0
Client: Windows 7 Ultimate x64

Thanks,

- Ken
Ken_LyonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
tickettConnect With a Mentor Commented:
Maybe try: http://www.methodicmadness.com/2009/06/clearing-sql-2008-management-studio.html

It may have an old incorrect password stored. I suggest renaming the file not deleting it (in case you want to restore it afterward).

L
0
 
Ken_LyonAuthor Commented:
Wow, that's amazing. I've never had such a speedy answer to a question. Thanks so much! It solved my problem to rename that file and let it generate a new one.
0
 
Ken_LyonAuthor Commented:
In case that link ever breaks, the solution was to delete/rename this file:

C:\Users\{username}\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

Subsequent use of SQL Server Management Studio re-created the file and the problem did not exist any more.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.