Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Increasing User connections in SQL SERVER 2005 Expand / Collapse
Author
Message
Posted Tuesday, February 3, 2009 5:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 11, 2009 3:11 AM
Points: 12, Visits: 27
Gurus,

Im new to SQL Server, please let me know how could I Increase user connections in SQL Server 2005.

Regards,
~Sridhar
Post #648730
Posted Tuesday, February 3, 2009 6:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 11, 2009 3:11 AM
Points: 12, Visits: 27
I worked on this optionn:

sp_configure 'user connections', 800;
GO
RECONFIGURE;
GO

But, was throwing
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'user connections' does not exist, or it may be an advanced option.

Any help...

Regards,
~Sridhar
Post #648763
Posted Tuesday, February 3, 2009 6:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 14,436, Visits: 37,820
yeah, not directly configurable without turning on advanced options.

i think this is what you are after:


--advanced options get enabled
sp_configure 'show advanced options', 1;
GO
RECONFIGURE
GO
--'user connections' 0=unlimited, change to an integer value if you wanted, say 800 maximum
sp_configure 'user connections', 0
GO
RECONFIGURE





Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #648772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse