• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 512
  • Last Modified:

SQL Server Max Connections

How do increase the mac connections of SQL server and was is the max setting?
0
deklinm
Asked:
deklinm
3 Solutions
 
Ross TurnerManagement Information Support AnalystCommented:
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
 
RaithZCommented:
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
 
David ToddSenior DBACommented:
Hi,

32767 is a fairly large number.

Why do you think you want to increase this?

Regards
  David
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now