Hi Rick, In su mode only one admin at a time is accepted, probably at the master DB restore time another admin was logged.
Check this or run server in multi user mode. Hope this helps. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Rick Adamson Sent: Wednesday, November 16, 2011 8:45 PM To: [email protected] Subject: [ADSM-L] TDP Restore of SQL 2008 master database 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. ----- Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute nel messaggio e negli eventuali allegati sono riservate al/ai destinatario/i indicato/i. Nel caso di erroneo recapito, si chiede cortesemente a chi legge di dare immediata comunicazione al mittente e di cancellare il presente messaggio e gli eventuali allegati. Si invita ad astenersi dall'effettuare: inoltri, copie, distribuzioni e divulgazioni non autorizzate del presente messaggio e degli eventuali allegati. ---------- According to Italian law (D.Lgs 196/2003) information contained in this message and any attachment contained therein is addressed exclusively to the intended recipient. If you have received this message in error would you please inform immediately the sender and delete the message and its attachments. You are also requested not to make copies, nor to forward the message and its attachments or disclose their content unless authorised.
