Sunday, March 11, 2012

Cannot login into server after single user mode

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...

how do I overcome this now.........Need to bring the server in multiple user mode...

any suggestions will be greatly appriciated.

Thanks

Have you removed the -m from the startup options?

|||how to remove -m from the startup parameters is the q?....now don't tell me right click and change at the properties....I cannot right click on the server ..it says ..cannot login only one user can login as administrator|||

You don't need to access SQL Server to remove this option. You need to:

1. Open Computer Management

2. Expand Services And Applications.

3. Expand SQL Server 2005 Services.

4. Find your SQL Server service and double click it.

5. Click on the Advanced tab.

6. Find the property called 'Startup Parameters'.

You need to be a little careful here, maybe copy and paste it into notepad so you can see the entire string. Remove the -m from the string and click ok. You will need to stop and re-start the SQL Server service for the changes to take affect.

HTH

Ray

|||

dude,

you still didn't understand the problem here.......when you give -m option in the startup parameters ...you cannot even right click on the EM .....it will throw you error saying only one admin can login in single user mode.... even though you

reboot the servers/service/////////what ever...

solution I found in the internet today morning.... is

go and change the registry for the parameter settings:

it worked like a charm.......

Thanks

Sameer

No comments:

Post a Comment