Problem accessing MICROSOFT##SSEE database (Error: 18456, Severity: 14, State: 16.)
- by Philipp Schmid
After an unexpected server shutdown due to a power failure, I can no longer connect to the internal windows database MICROSOFT##SSEE which is hosting Central Admin for my SBS 2008 server.
The log shows:
Error: 18456, Severity: 14, State: 16.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <named pipe>]
I've tried to connect using the SQL Management studio (connecting to .pipemssql$microsoft##sseesqlquery) but no luck.
The SQL Server Configuration Manager doesn't show a entry for 'Protocols for MICROSOFT##SSEE' (but shows it for 2 other database hosted on the same SQL server 2005 Express edition.
I have tried to restore the master.ldf and mastlog.log files from a backup, but the issue persists.