SQL SERVER 2008 R2最大并发连接数修改为2后,SQL连接无法超过2个。
执行:
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
RECONFIGURE WITH OVERRIDE
GO