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."