Home / server / Questions / 138779
In Process
Philipp Schmid
Asked: 2010-05-06 05:12:23 +0800 CST

Problem accessing MICROSOFT##SSEE database (Error: 18456, Severity: 14, State: 16.)

  • 772

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.

sql-server-2005 login sql

1 Answers

  1. Have you tried using sqlcmd to connect to the service when it's running in single user mode?

    Configure the service's startup options for '-m' and restart the service.

    Then use this to connect from a command line:

    sqlcmd -E -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

    Alternatively, this article can help you connect via SSMS in single user mode: http://msdn.microsoft.com/en-us/library/ms188236.aspx

    Check and see if 'NT AUTHORITY\NETWORK SERVICE' has a login to the instance with login rights.

    • 1