Cannot connect to SQL server after setting user connections to 1

I have a problem connecting to SQL Server 2005. After I set "user
connections" to 1 and restarted sql service, I cannot connect to server
anymore. Do you have maybe any suggestion how to set "user connection" back
to 0? It's a SQL Server 2005 Standard with SP1 in two node cluster.
Thanks!
BogdanDisconnect the network to make sure nobody can log in and then set SQL Agent
to manual start to make sure it doesn't grab your only connection. Also
look for any other services that might be grabbing the connection. Stop and
start the SQL service and see if you can get in. Good luck.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Bogdan" <Bogdan@.discussions.microsoft.com> wrote in message
news:2418A056-42A7-43CB-984B-E60A84BB124C@.microsoft.com...
>I have a problem connecting to SQL Server 2005. After I set "user
> connections" to 1 and restarted sql service, I cannot connect to server
> anymore. Do you have maybe any suggestion how to set "user connection"
> back
> to 0? It's a SQL Server 2005 Standard with SP1 in two node cluster.
> Thanks!
> Bogdan|||Note - this assumes you are running SQL Server 2000. If you are running SQL
Server 2005 you can use the administration connection to get in.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ev2PsHaZGHA.1200@.TK2MSFTNGP03.phx.gbl...
> Disconnect the network to make sure nobody can log in and then set SQL
> Agent to manual start to make sure it doesn't grab your only connection.
> Also look for any other services that might be grabbing the connection.
> Stop and start the SQL service and see if you can get in. Good luck.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Bogdan" <Bogdan@.discussions.microsoft.com> wrote in message
> news:2418A056-42A7-43CB-984B-E60A84BB124C@.microsoft.com...
>