December 2, 2011 at 5:53 pm
Hi
we have Active/passive cluster and I have an issue with regards to the master database and part of it I was trying to restore the master database and in order to do that firstly I tried to place the sql server in single user mode and I am a sysadmin on the sql server instance after restarting the sql server services (-m; option) the sql server is going in single user mode but when I'm trying to make a connection to sql server using sqlcmd from command prompt it says:
"login failed for use domainxyz\abcdlogin because server is in single user mode and only administrator can connect to it"
and this is the message I get and the sql server is running under separate service account i.e. abcddomain\xyzlogin. This is really urgent can anyone let me know why I am not able to make a connection
Thanks,
Ravi
December 2, 2011 at 6:52 pm
Do you have any other processes that are connecting into SQL Server that has the SA role. One thing you can to is disable the logins for any other users then retry.
Hope this helps.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply