Home Page

Home Page
How to Search the Query

Sunday 6 April 2014

SQL Server : database connection issue locally and over the networks

While Connecting to the SQL Database, its throwing an error : Could not connect because the maximum number of user connections has already been reached.

 



 Event Viewer Log :

 

Follow below Procedure to get resolve this issue :

In the Object Explorer, right click on the server, to open the Properties. Go to the Connections page, it will show you, how many connections instance is configured to accept the users.

Open SQL Management Studio and connect to local database using Windows or SQL Authentication Right Click on Server or local Instance Name and open proprieties.

 

Click on Connections and increase the "Maximum number of concurrent connections" (0 = Unlimited)
Note : Increase the Numbers or set the "0" for unlimited connections.






Searches Related Links:
SQL Server database connection issue locally and over the network
maximum number of user connection has already been reached
the system administrator can be use sp_configure to increase the maximum value
the connection has been closed
MSSQLSERVER Event ID 17809
A connection was successfully established with the server but then an error occurred during the login process
SQL Server error : The specified network name is no longer available
Microsoft SQL Server, Error:64

No comments:

Post a Comment

Thank you for logging in.. Waiting for your valuable views.