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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Rick Adamson
Sent: Wednesday, November 16, 2011 8:45 PM
To: ADSM-L AT VM.MARIST DOT EDU
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.
|