Post reply

HOW can we start Multi user mode

  • August 21, 2009 at 7:23 am

    #213582

    I had start my server 2000 in Single user mode know how can i start multi user mode

    ERROR :

    Server : Msg 18461

    [Microsfot][ODBC -sql server driver[sqlserver] login failed for user

    'XXX\adminstor' Reason Sql server in single user mode. Only one

    administrator can connect at this time.

    Any body plz explain me step by step

    how can i start multi user mode

    Regards

    Kumar

  • August 21, 2009 at 7:24 am

    #1042813

    run this command

    alter database mydb set multi_user

    Edit - This would put the database in single user mode not the server.

    Also, this is a dupicate post. Please post your replies to

    http://www.sqlservercentral.com/Forums/Topic774795-146-1.aspx


    Pradeep Singh

  • August 21, 2009 at 7:29 am

    #1042817

    Hi This is not Database issue

    It is only server issue

  • August 21, 2009 at 7:30 am

    #1042821

    I think the error says your SERVER is in single user mode, not the database.

    Is it possible you started the service with the -M switch?

    Cheers,

    J-F

  • August 21, 2009 at 7:59 am

    #1042840

    Also asked here: http://www.sqlservercentral.com/Forums/Topic774795-146-1.aspx

    No more replies to this thread please.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply