Solved

SQL Server Max Connections

Posted on 2013-01-21
3
481 Views
Last Modified: 2013-02-09
How do increase the mac connections of SQL server and was is the max setting?
0
Comment
Question by:deklinm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 7

Accepted Solution

by:
Ross Turner earned 167 total points
ID: 38802727
SQL server will allow 32767 (this is the value returned by select @@max_connections) connections and this setting can be changed using sp_configure 'user connections'.
0
 
LVL 6

Assisted Solution

by:RaithZ
RaithZ earned 167 total points
ID: 38802729
There is 2 places that could be considered max connections.. here is where to set it in SQL server itself:

http://msdn.microsoft.com/en-us/library/ms179874%28v=sql.105%29.aspx

Here is where you can configure it in windows (in case windows can't handle the number of connections going to your SQL server):

http://msdn.microsoft.com/en-us/library/ms190219%28v=sql.105%29.aspx

The later would not normally need to be set, but in case you still run into issues after configuring the SQL connections, it may help.
0
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 166 total points
ID: 38802891
Hi,

32767 is a fairly large number.

Why do you think you want to increase this?

Regards
  David
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

752 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