August 20, 2009 at 11:53 pm
Hi Every body,
I am using MS SQL SERVER 2000
I am getting below error:
Login failed user 'xxx\administrator' Reason server in single user mode. only one administrator can connect at this time
how can come to multiuser mode can any body plz explain me
what are steps i have follow to reslove this prob plz suggest me correct way.
Reagardsd
August 21, 2009 at 12:22 am
You need to set the restrict acess to multi_user. Only administrator login can set the same.
August 21, 2009 at 12:57 am
if the database is in single user mode thats probably for a reason. you need to find out who put it in single user mode as they probably have the only connection.
once you have the connection you need to run the following
alter database
set multi_user
go
August 21, 2009 at 1:49 am
The error's not saying that the database is in single user mode, it's saying that the server is in single user mode.
So someone has started SQL with the -m switch which means that the SQL Service will only allow one connection.
Fix is to shut SQL down (from services panel if it's running as a service), remove the -m command line switch (why the hell it would be there is a completely different question) and restart the server.
If SQL's running as a standalone app (someone ran SQLServr.exe -m from the command line) then that session should be terminated (ctrl-C) and SQL restarted as a service.
I guess the first thing I really want to know is who started SQL in single user mode and why.
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
August 21, 2009 at 6:49 am
Hi Gila,
Thanks your reply,
Two days back we have to start sql server 2000 in Enterprice manager in the parameters we have put -m.
But right know in EM is not connect it how can i start the server in multiuser mode
could you please explaine me step by step What are the steps have to follow suggest me
Regards
kumar
August 21, 2009 at 6:57 am
GilaMonster (8/21/2009)
The error's not saying that the database is in single user mode, it's saying that the server is in single user mode.
Well spotted 🙂 My apologies - ignore my response
August 21, 2009 at 7:10 am
Hi Gila,
In SQL SERVER 2000 We have maintain Two(2) Instances
1.'xxx-15878
2.'xxx-1345\xxx'
These are the two instances we have maintain
In the 2 nd instance in that EM in parameters we have put -m some other purpose
how can i start in multi user mode plz explaine me step by step
and you suggest me go CMD sqlservr.exe-m i had done it will giving this error
ERROR:
sql server installation is either corrrupt or has been tampered with (SQL Registry version not same as
server) please uninstall then re-run step to correct this prob.
how can i slove this prob plz suggest me
August 21, 2009 at 8:02 am
Can't remember sql 2000 very well. The only way you're going to fix this is by removing that -m.
Go to Services (Control panel-administrative tools-Services), find the SQL Server service and check the start up parameters there. If the -m is listed there, remove just that. Don't tamper with the other command line parameters.
Stop SQL from the services app and then restart it from there with the -m removed.
If the -m switch doesn't appear in the command line parameters, stop SQL from the services app and restart it. See if that helps.
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
August 21, 2009 at 8:35 pm
Hi Gila,
Thank you very much
I got every thing as same as before
Thank you very much for your help
really appriciate to other guys also ....
Regards
Kumar
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply