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

posted @ 2012-07-24 11:18  brian_lee  阅读(6312)  评论(0编辑  收藏  举报