?
Solved

MS SQL SERVER maximum connections (3) has already been reached

Posted on 2012-09-12
8
Medium Priority
?
1,567 Views
Last Modified: 2012-09-13
On 9/7, our SQL Server Express Database started to report Event ID 17809 "Maximum number of connection (3) has already been reached" .   As far as I know, no changes were made to the database/server.   The last windows updates were installed on 7/19.  The server was rebooted on 7/26 and then not until 9/6.
We ran the SP_Configure query:
sp_configure 'show advanced options', 1
go
reconfigure
go
sp_configure 'user connections', 0
go

If I look in the SQL Server Connection properties, Maximum Num of Server Connections = 0
and Allow Remote Connections is checked and query timeout = 0

Thanks for any help!  -j
0
Comment
Question by:juli
  • 4
  • 4
8 Comments
 
LVL 15

Expert Comment

by:Anuj
ID: 38390908
Did you done the following?

sp_configure 'user connections', 0
GO
RECONFIGURE WITH OVERRIDE
GO
0
 

Author Comment

by:juli
ID: 38390929
I didn't but I will.   Stay tuned...
0
 

Author Comment

by:juli
ID: 38390934
This is the message after running the above query:  
Configuration option 'user connections' changed from 0 to 0. Run the RECONFIGURE statement to install.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 15

Expert Comment

by:Anuj
ID: 38390964
Did you run RECONFIGURE WITH OVERRIDE after that?
0
 

Author Comment

by:juli
ID: 38391080
The first time I ran the query as you wrote it (both at the same time).    I ran them seperately and the RECONFIGURE WITH OVERRIDE said that it completed successfully.
However, I'm still having the problem with the 3 connection limit.  If I try to do anything else in SQL Mgmt Studio (open another New Query, for example) it will disconnect my session and I'll see the error in the Event Viewer.
I have not rebooted the server since running any of these database queries.  It didn't seem necessary but am open to any suggetions.
0
 
LVL 15

Expert Comment

by:Anuj
ID: 38391125
If you change this configuration, You should restart the SQL Server Service to take effect, this is what MSDN says here.
0
 

Author Comment

by:juli
ID: 38391485
Restarting the service might have done the trick (I should have considered that before...)
I need to see what happens when several people are working with the database application but my initial testing looks promising.    Thanks for your prompt replies and suggetions.
0
 
LVL 15

Accepted Solution

by:
Anuj earned 2000 total points
ID: 38391508
Glad that it is solved, please mark my post as answer if that helps you.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question