InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 00:28:22 GMT20http://www.sqlservercentral.com/Forums/Topic648730-146-1.aspxyeah, not directly configurable without turning on advanced options.i think this is what you are after:[code][font="Courier New"][size="2"][color="black"][/color][color="green"]--advanced options get enabled[/color][color="darkred"]sp_configure [/color][color="red"]'show advanced options'[/color][color="gray"], [/color][color="black"]1[/color][color="gray"]; [/color][color="black"]GO [/color][color="blue"]RECONFIGURE [/color][color="black"]GO [/color][color="green"]--'user connections' 0=unlimited, change to an integer value if you wanted, say 800 maximum[/color][color="darkred"]sp_configure [/color][color="red"]'user connections'[/color][color="gray"], [/color][color="black"]0 GO [/color][color="blue"]RECONFIGURE[/color][/size][/font][/code]Tue, 03 Feb 2009 06:20:27 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic648730-146-1.aspxI worked on this optionn:sp_configure 'user connections', 800;GORECONFIGURE;GOBut, was throwing Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51The configuration option 'user connections' does not exist, or it may be an advanced option.Any help...Regards,~SridharTue, 03 Feb 2009 06:12:04 GMTsridhar.tondapihttp://www.sqlservercentral.com/Forums/Topic648730-146-1.aspxGurus, Im new to SQL Server, please let me know how could I Increase user connections in SQL Server 2005.Regards,~SridharTue, 03 Feb 2009 05:23:22 GMTsridhar.tondapi