Get value for max user connections per server:
Set value for max user connections:
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."