SQL 2008 rejects correct password when logging in to Management Studio
Posted on 2010-08-24
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