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 |
|
SAAM1
Starting Member
1 Post |
 Posted - 2007-09-03 : 09:57:11
|
| Stopped the sqlserver agent first. included -m option in the startup options of the SQL SERVER virtual server . restarted the sql server .. Now it is in single user mode. after this I cannot do anything I cannot even right click on the server " throws me error saying server in single user mode user cannot login" Database is sqlserver 2000 os win2003 clustered 2 nodes. rebooted the nodes , restarted the sql server many times tried login with sa, services running user account. still cannot login into the server thru EM from outside and from server itself. sql server agent cannot be brought up....it says failedhow do I overcome this now.........Need to bring the server in multiple user mode...any suggestions will be greatly appriciated.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-03 : 13:06:08
|
| Restart sql without -m option. |
 |
|
|
|
|
|
cannot login after single user mode