数据库最大连接数问题

Question

数据库报错：could not connect because the maximum number of '100' user connections has already been reached.the system administrator can use sp_cconfigure to increase the closed.但是我把连接数改到200还是报这个错，错误代码17809，数据库版本sql server2005

Answer 1

http://www.tuicool.com/articles/AzueyyE
exec sp_configure 'user connections',0
go
reconfigure with override
go