This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Lao DAs!! please help me with this SQL Server problem!!! thanks!Hi Buddie,
Please help me!!!!
My sql server 7.0 is set to single user mode by accident,
now sql server can be started as the pc reboots which take the internal account, so I cannot connect to sql server using MMC or query Anlyzer.
now my sql server is out of control, HOW can I re-set
the connection to 0/mutile-user!!!!!??????????
any ideas are appreciated!
-bigdesk(KISS FM);
2001-11-24
{371}
(#274468@0)
-
just an idea, hopefuly it helpsmy understanding of your problem was,
you set the mode to single user, then
when you reboot, you could not connect
to the server anymore,
stop SQL Executive service and try to
connect to the server again, if still
doesn't work, try to stop all the SQL
services, and reboot the machine,
start SQL manually
I'm not an expert on this, just an idea
dont forget to share when you resolve it
-rootbear(喝点啤酒晕晕头);
2001-11-25
{407}
(#274525@0)
-
thanks buddi, actually I have tried many times as you said before, but it didn't work. under any situation, the internal account is the first time to be used.it's my fault, acually I want to restore master database from a earlier backup copy, which requires the single user connection mode to set, when I saw the waning info dailg, I just "Click" the wrong YES which made me into deep trouble. St!!
thanks anyway!
-bigdesk(KISS FM);
2001-11-25
{261}
(#274531@0)
-
well,,,索性在命令行再用单用户方式启动一下试试，
一个朋友应用程序把一个表CORRUPT啦，
整个数据库挂起来，费了好大劲才RESTORE
祝你好运，呵呵
-rootbear(喝点啤酒晕晕头);
2001-11-25
{132}
(#274560@0)
-
唉，数据库挂起还可以用attach命令弄回来，我这问题是没法进连上sqlserver呀。多谢！
-bigdesk(KISS FM);
2001-11-25
(#274588@0)
-
hope this works,http://support.microsoft.com/support/kb/articles/Q259/5/51.ASP
-canadapassenger(独在异乡为异客);
2001-11-25
(#274614@0)
-
The easiest way is to stop and restart the sql server service. ( don't specify the -m option when you start the service.
-yangn(Raymond);
2001-11-25
(#274672@0)
-
it's done. in service manager I specify the optional paramter -m in the paramter box and then start the sql server.it seems sql server let me use this explicitly single user mode so i can connect to the sever and change back the allowable connection to 0.
good, thanks!
-bigdesk(KISS FM);
2001-11-25
{155}
(#275294@0)
-
ms base number: Q200103.
-bigdesk(KISS FM);
2001-11-25
(#275299@0)