Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 @ 4:51 AM
Points: 12,918, Visits: 32,085
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #648772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse