×

Loading...

Topic

This topic has been archived. It cannot be replied.
  • 工作学习 / IT技术讨论 / Lao DAs!! please help me with this SQL Server problem!!! thanks! -bigdesk(KISS FM); 2001-11-24 {371} (#274468@0)
    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!
    • just an idea, hopefuly it helps -rootbear(喝点啤酒晕晕头); 2001-11-25 {407} (#274525@0)
      my 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
      • 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. -bigdesk(KISS FM); 2001-11-25 {261} (#274531@0)
        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!
        • well,,, -rootbear(喝点啤酒晕晕头); 2001-11-25 {132} (#274560@0)
          索性在命令行再用单用户方式启动一下试试，
          一个朋友应用程序把一个表CORRUPT啦，
          整个数据库挂起来，费了好大劲才RESTORE
          祝你好运，呵呵
          • 唉，数据库挂起还可以用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. -bigdesk(KISS FM); 2001-11-25 {155} (#275294@0)
        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!
      • ms base number: Q200103. -bigdesk(KISS FM); 2001-11-25 (#275299@0)
枫下论坛主坛 /  工作学习 /  IT技术讨论