|
|
You're in the
sql server connect
group:Cannot connect to SQL server after setting user connections to 1
sql server connect:
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!
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 [quoted text, click to view] "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 [quoted text, click to view] "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... >>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 > >
Thanks for suggestion about DAC. Unfortunately DAC (Dedicated Administrator
Connection) is not enabled on cluster configuration by default and I can't enable DAC (execute the remote admin connection option of sp_configure) without connecting to SQL, but I can't do that because of only 1 permited connection, which is obviously taken by some process (I've tried disconect network and second cluster node, but it didn't help). It looks like the only solution is to reinstall SQL Server :-(. Regards, Bogdan [quoted text, click to view] "Roger Wolter[MSFT]" wrote:
> 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... > >>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 > > > > > >
web sites and software manufacturers should get a smart "neo-user"
to try out software before it is released. This smart "neo-user" should not know members of the developing team for obvious reasons. [quoted text, click to view] "Bogdan" wrote:
> Thanks for suggestion about DAC. Unfortunately DAC (Dedicated Administrator > Connection) is not enabled on cluster configuration by default and I can't > enable DAC (execute the remote admin connection option of sp_configure) > without connecting to SQL, but I can't do that because of only 1 permited > connection, which is obviously taken by some process (I've tried disconect > network and second cluster node, but it didn't help). It looks like the only > solution is to reinstall SQL Server :-(. > > Regards, > Bogdan > > "Roger Wolter[MSFT]" wrote: > > > 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... > > >>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 > > > > > > > > > >
Try checking the SQL Server error log at <your path such as C:\Program
Files\> Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG. It probably lists the login which has grabbed the connection which may give you some more ideas. -- Rick Byham MCDBA, MCSE, MCSA Documentation Manager, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. [quoted text, click to view] "Bogdan" <Bogdan@discussions.microsoft.com> wrote in message news:30B504B0-304C-4D80-8BAA-8AA6057F0277@microsoft.com... > Thanks for suggestion about DAC. Unfortunately DAC (Dedicated > Administrator > Connection) is not enabled on cluster configuration by default and I > can't > enable DAC (execute the remote admin connection option of sp_configure) > without connecting to SQL, but I can't do that because of only 1 permited > connection, which is obviously taken by some process (I've tried disconect > network and second cluster node, but it didn't help). It looks like the > only > solution is to reinstall SQL Server :-(. > > Regards, > Bogdan > > "Roger Wolter[MSFT]" wrote: > >> 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... >> >>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 >> > >> > >> >> >>
thanks! When I finally discover the concept, many questions on this forum
will be answered. [quoted text, click to view] "Rick Byham [MS]" wrote:
> Try checking the SQL Server error log at <your path such as C:\Program > Files\> Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG. It probably lists > the login which has grabbed the connection which may give you some more > ideas. > -- > Rick Byham > MCDBA, MCSE, MCSA > Documentation Manager, > Microsoft, SQL Server Books Online > This posting is provided "as is" with > no warranties, and confers no rights. > > "Bogdan" <Bogdan@discussions.microsoft.com> wrote in message > news:30B504B0-304C-4D80-8BAA-8AA6057F0277@microsoft.com... > > Thanks for suggestion about DAC. Unfortunately DAC (Dedicated > > Administrator > > Connection) is not enabled on cluster configuration by default and I > > can't > > enable DAC (execute the remote admin connection option of sp_configure) > > without connecting to SQL, but I can't do that because of only 1 permited > > connection, which is obviously taken by some process (I've tried disconect > > network and second cluster node, but it didn't help). It looks like the > > only > > solution is to reinstall SQL Server :-(. > > > > Regards, > > Bogdan > > > > "Roger Wolter[MSFT]" wrote: > > > >> 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... > >> >>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 > >> > > >> > > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |