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 SQL Server with 'sa'

Hi,
After I setup 'sa' password in SQL Server 2005, I get out SQL Server and
re-login using SQL Authentication mode with 'sa' and pasword, I get error:
"A connection was successfully established with the server, but then the
error occured during the login process. (Provider: Shared memeoryprovider,
error 0 - No process is on the other end of the pipe.) (Microsoft SQL Server
: error 233)"
Please help
Thanks
kaiDo you have Shared Memory connections enabled? Run the SQL Server
Configuration Manager and look at the protocols and shared Memory to see if
it is enabled or not.
Andrew J. Kelly SQL MVP
"kai" <kailiang@.earthlink.net> wrote in message
news:5HZqf.9593$nm.595@.newsread2.news.atl.earthlink.net...
> Hi,
> After I setup 'sa' password in SQL Server 2005, I get out SQL Server and
> re-login using SQL Authentication mode with 'sa' and pasword, I get error:
> "A connection was successfully established with the server, but then the
> error occured during the login process. (Provider: Shared memeoryprovider,
> error 0 - No process is on the other end of the pipe.) (Microsoft SQL
> Server : error 233)"
> Please help
> Thanks
> kai
>|||Andrew,
Thanks for your help. I checked it, it is enabled. I found additional
error when I login second time:
"Login failed for user 'sa'.The user is associated with a trusted SQL Server
connection. (Microsoft SQL Server, error: 18452)
Kai
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23pGIiaACGHA.736@.TK2MSFTNGP10.phx.gbl...
> Do you have Shared Memory connections enabled? Run the SQL Server
> Configuration Manager and look at the protocols and shared Memory to see
> if it is enabled or not.
> --
> Andrew J. Kelly SQL MVP
>
> "kai" <kailiang@.earthlink.net> wrote in message
> news:5HZqf.9593$nm.595@.newsread2.news.atl.earthlink.net...
>|||See if this may help:
http://support.microsoft.com/?id=328306
Andrew J. Kelly SQL MVP
"kai" <kailiang@.earthlink.net> wrote in message
news:jB_qf.9068$3Z.3336@.newsread1.news.atl.earthlink.net...
> Andrew,
> Thanks for your help. I checked it, it is enabled. I found additional
> error when I login second time:
> "Login failed for user 'sa'.The user is associated with a trusted SQL
> Server connection. (Microsoft SQL Server, error: 18452)
> Kai
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23pGIiaACGHA.736@.TK2MSFTNGP10.phx.gbl...
>|||Is it possible you're trying to connect multiple times over the dedicated
Admin connection?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"kai" <kailiang@.earthlink.net> wrote in message
news:jB_qf.9068$3Z.3336@.newsread1.news.atl.earthlink.net...
> Andrew,
> Thanks for your help. I checked it, it is enabled. I found additional
> error when I login second time:
> "Login failed for user 'sa'.The user is associated with a trusted SQL
> Server connection. (Microsoft SQL Server, error: 18452)
> Kai
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23pGIiaACGHA.736@.TK2MSFTNGP10.phx.gbl...
>
>|||Hi Kai,
Generally speaking, error code 18452 suggests SQL Authentication is not
enabled. Would you please check to see whether it was enabled?
- Right Click the instance name in the Object Explorer, select Properties
- Select Security page and make sure SQL Server and Windows Authentication
mode is selected.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Michael ,
Thank you for your help.
It is enabled. I check my other two SQL Servers, they all have the same
problems.
Kai
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:8qxTKFFCGHA.3992@.TK2MSFTNGXA02.phx.gbl...
> Hi Kai,
> Generally speaking, error code 18452 suggests SQL Authentication is not
> enabled. Would you please check to see whether it was enabled?
> - Right Click the instance name in the Object Explorer, select Properties
> - Select Security page and make sure SQL Server and Windows Authentication
> mode is selected.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Michael,
Thank you very much for your help.
When I installed SQL Server 2005 initially, I use Wondows Authentication
mode. After the installation, I changed to Mixed mode. Then I setup the new
password for 'sa' and other SQL Server logins, I cannot login with any SQL
logins.
I just found out the Login properties (status) for those SQL logins ware
setup to "Disable" by default, after I change them to "Enaled", I can login
with SQL logins.
Thank you so much !!!
Kai
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:g8q%235hfCGHA.3992@.TK2MSFTNGXA02.phx.gbl...
> Hi Kai,
> This issue occurs because SQL Server Management Studio cannot correctly
> report the error when the maximum number of concurrent connections has
> been
> reached.
> To work around this issue, you can use the sp_configure Transact-SQL
> procedure to increase the maximum number of concurrent connections. You
> can
> also manage the instance of SQL Server 2005 in other ways. For example,
> you
> can use the sqlcmd utility.
> To use sp_configure to increase the maximum number of concurrent
> connections, follow these steps:
> 1. Click Start, click Run, type cmd, and then click OK.
> 2. At the command prompt, type the following command, and then press
> ENTER.
> sqlcmd.exe -E -S servername
> 3. When you successfully connect to the instance of SQL Server 2005,
> execute the following Transact-SQL statements at the SQL Server prompt.
> sp_configure 'user connections', <NewNumber>
> Go
> Reconfigure
> Go
> 4. Restart the SQL Server service for the change to take effect.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Kai,
Happy New Year! You are welcome!
If you have any questions or concerns next time, don't hesitate to let me
know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||By default max no. of connections is set to 10.
To increase the maximum no. of connections
1. In Object Explorer, right-click a server and click Properties.
2. Click the Connections node.
3. Under Connections, in the Max number of concurrent connections box, type
or select a value from 0 through 32767 to set the maximum number of users
that are allowed to connect simultaneously to the instance of SQL Server.
set it to 0 (it means unlimited connections)

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