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 |
|
Sqlbuddy
Starting Member
27 Posts |
 Posted - 2009-05-15 : 17:01:40
|
| Hi, To move the model database, I have restarted SQL Server using -c -m -T3608 (using Configuration manager). But when I try to connect to the instance, I am unable to login to the system. It shows me the error:Login failed for the user. The reason: Server is in single user mode.Only one administartor can connect at this time. ( Microsoft SQL Server error:18461I am the only admin on my system. Could anyone please tell me how to login to my instance and then execute detach command in the query editor? Thank you,Yours SQL Buddy. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-05-15 : 17:36:19
|
http://www.mydatabasesupport.com/forums/sqlserver-server/201096-manage-server-single-user-mode.html
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
How to connect to the instance in single user mode