[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL 2008 rejects correct password when logging in to Management Studio

Posted on 2010-08-24
3
Medium Priority
?
478 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:Ken_Lyon
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
tickett earned 200 total points
ID: 33513234
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
 

Author Closing Comment

by:Ken_Lyon
ID: 33513314
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
 

Author Comment

by:Ken_Lyon
ID: 33513322
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question