How To Solve SQL Connection Error 10053 : Event ID : 17809
Error Message :
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).
Event Log :
Could nor connect because the maximum number of ‘2’ user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT : 192.168.8.74].
Solution :
Step 1. First Go to services and stop Services named SQL Server (MSSQLSERVER).
Step 2. Now, start both SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER).
That’s it, now you can connect to your database or you can increase the number of connection using sp_configure.
0 comments:
Post a Comment