I have been asked to restore the master DB on a Windows 2008 cluster for
SQL Server 2008 and have no problems putting the SQL server in
single-user mode but the restore still fails. The error message is
11/16/2011 13:21:31 ACO5424E Could not connect to SQL server; SQL server
returned:
11/16/2011 13:21:31 Failed to connect to server sqlserverinstance-name.
11/16/2011 13:21:31 Login failed for user 'username'. Reason: Server is
in single user mode. Only one administrator can connect at this time.
(HRESULT:0x80131501).
I have shut down all services except the SQL Server service (SQL Agent,
reporting services, etc.), closed all SQL tools (config mngr, SQL
studio,etc.) monitored the authentication logging on the SQL Server in
hopes of identifying the culprit, and even setup a IPSEC policy
limiting access to the server only for RDP and the TSM server .... and
no success.
Has anyone experienced this behavior and found out what the issue is? Am
I missing something?
TDP Client version 5.5.4.2
TSM Server version 5.5.5.2
I am able to restore other (non-master) databases.
Thanks in advance....
~Rick
Jacksonville, FL.
|