Am o aplicatie ce foloseste SQL Server 2005. I-am facut deploymentul, insa primesc o eroare de genu:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.)
Mergand mai departe am observat ca si celelalte aplicatii care se foloseau de serveru meu nu mai functioneaza.
Am ajuns sa ma uit in log sa vad care ar putea fi problema. Asta am reusit sa aflu de acolo:
2007-09-25 15:30:32.14 Logon Could not connect because the maximum number of '3' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
2007-09-25 15:30:32.14 Logon Error: 17809, Severity: 20, State: 3.
Am citit in unele locuri ca pot scapa de problema aceasta daca folosesc sp_configure ca sa cresc nr. de conexiuni.
Si am vrut sa intru, dar nu ma mai pot conecta la server prin SSMSE din cauza erorii de mai sus.
Cum sa folosesc eu query analyser si comanda sp_configure daca nu ma pot conecta la server? Ce pot sa fac? Si in primul rand ce genereaza problema mea? Am aflat ca sunt 3 conexiuni la serverul meu. Cum pot sa le opresc?
Mentionez ca folosesc SQL Server 2005 si ca protocoalele pt. named pipes, tcp/ip si shared memory sunt enabled.
Calin Drimbau