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
The error still occurs, any suggestions?