Cannot open SQL Analyzer in Single User Mode

Hi

I have been having a problem with what I suspect are corrupted indexes. When I try to open the SQL Analyzer window when I have the database in Single User Mode I get the following error:

Msg 4060 Level 16

Cannot open database requested in login 'Timemaster'. Logion Fails

I am using the sa user to login and the password is correct.

SQL Analyzer opens correctly when not restricted to single user mode.

Hope you can help.

Susan

Are you trying to set the database in single user mode or the server in single user mode? This sounds like a misunderstanding of the meaing of what is being set to "single user". If you are trying to set the database into single user mode, please verify that you have database owner privilege on the targeted database.

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

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