DevNitin: Set value for max user connections

Aug 20, 2014

Set value for max user connections

Get value for max user connections per server:

SELECT * FROM sys.configurations
where name = 'user connections'

Set value for max user connections:


EXEC sys.sp_configure N'show advanced options', N'1'  RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'user connections', N'0'
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'show advanced options', N'0'  RECONFIGURE WITH OVERRIDE
GO

 

PS:  you have to connect your SSMS with admin privilages,

You can set the value of max user connections to 0

when you get the error "provider: Shared Memory Provider,

error: 0 - No process is on the other end of the pipe."