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

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
gtrappAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
If ALTER LOGIN didn't worked, then sp_defaultdb should have worked..
Even this is what is suggested in Microsoft Article:

http://support.microsoft.com/kb/307864

Check this one out:

http://benharrell.wordpress.com/2007/01/15/cannot-open-user-default-database-login-failed-login-failed-for-user-username-microsoft-sql-server-error-4064/
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Try running the script below:

exec sp_defaultdb '[PBTF\Group - IT DB Admins]', 'master'

PS: Run this script from a user having sa rights or securityadmin role..
0
 
gtrappAuthor Commented:
Ran the script. It ran successfully. I closed down SQL Server Management Studio and reconnected to the MICROSOFT##SSEE. The 4064 error still occurs.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
gtrappAuthor Commented:
OK, I think I need to call MS Support. Can't seem to fix the problem.
0
 
gtrappAuthor Commented:
rrjegan17 did a good job with the comments, but it did not sovle the problem. I need to call MS for help.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> Can't seem to fix the problem.

Ok..And if you share the solution which you got from Microsoft once it is resolved, it would be helpful for others who might be visiting this thread later on..
0
All Courses

From novice to tech pro — start learning today.