troubleshooting Question

Login failed for user - Microsoft SQL Server, Error: 4064

Avatar of gtrapp
gtrapp asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
6 Comments1 Solution1385 ViewsLast Modified:
Hello,

When I click on properties of a database, users, tables, or any object within SQL Server Management Studio, I get this error:

Cannot show requested dialog.
Cannot open user default database. Login failed.
Login failed for user 'PBTF\bob'. (Microsoft SQL Server, Error: 4064)

The login does exist in the security group. The database is a WSS 3.0 database, with an instance of MICROSOFT##SSEE

In the event log, the event occurs when the error message occurs in SQL Server Management Studio:

The description for Event ID ( 18456 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer.

I ran the following command and there were no errors. It seemed to work, but I tried viewing properties in Management Studio and the error still occurs:

C:\>sqlcmd -E -d master -S THOTH\MICROSOFT##SSEE
1> ALTER LOGIN [PBTF\Group - IT DB Admins] WITH DEFAULT_DATABASE = master
2> go

The error still occurs, any suggestions?

Thanks,

Paul
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros