Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bintaleb
Starting Member
2 Posts |
 Posted - 2009-02-14 : 00:58:58
|
| Hi My friendsI have simulated master DB is failure after backing up it and run sql server in single-user mode (it works perfectly) and then I have tried to use sqlcmd to restore master DB but I have received error message says "only one administrator can connect to the server at on time".note: I am using Windows XP professional. SQL server 2005 developer edition access to sql server by window authenticationkindly, how can I get access to sqlcmd by single-user mode or what is the reason which prevent me to get access.My Best Regards |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-14 : 10:04:27
|
| Are you admin in server? |
 |
|
|
bintaleb
Starting Member
2 Posts |
Posted - 2009-02-15 : 01:01:23
|
| yes |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-02-24 : 04:58:50
|
quote:
Originally posted by bintaleb
Hi My friendsI have simulated master DB is failure after backing up it and run sql server in single-user mode (it works perfectly) and then I have tried to use sqlcmd to restore master DB but I have received error message says "only one administrator can connect to the server at on time".note: I am using Windows XP professional. SQL server 2005 developer edition access to sql server by window authenticationkindly, how can I get access to sqlcmd by single-user mode or what is the reason which prevent me to get access.My Best Regards
the message says that an admin is already connected to the database and u r trying to connect as a sceond user..I believe u ran the single user mode command from SSMS... and u ran sqlcmd with out logging out from the SSMS...Regards,Ahmad Osama |
|
|
|
|
|
|
sqlcmd in single-user mode dose not work.