sql不定期无法登入
sql2000数据库，每过几天前台程序就不能登入，登入时提示：
服务器连接失败，请检查网络
连接错误：[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
经测试网络正常，从服务器的日志来看，有如下出错的日志：
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17052
Date:2013-8-23
Time:10:20:28
User:N/A
Computer:EDPSQL06
Description:
Error: 17809, Severity: 20, State: 1
Could not connect. The maximum number of '500' configured user connections are already connected. The system administrator can change the maximum to a higher value using sp_configure.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 91 45 00 00 14 00 00 00 ?E......
0008: 09 00 00 00 45 00 44 00 ....E.D.
0010: 50 00 53 00 51 00 4c 00 P.S.Q.L.
0018: 30 00 36 00 00 00 00 00 0.6.....
0020: 00 00 ..
哪位高手能否指导一下该如何处理? SQL 网络 服务器
[解决办法]
Could not connect. The maximum number of '500' configured user connections are already connected. The system administrator can change the maximum to a higher value using sp_configure.
无法连接。最大数量的“500”配置的用户连接已经连接。系统管理员可以改变到一个更高的值使用sp_configure最大。
请用sa用户登录把最大连接数改为更高1000，改为0表示不受连接数限制
[解决办法]
系统配置有设定最大连接数为500,超过500就无法连接了.
修改系统配置参数user connections
use master
go
sp_configure 'user connections',32767
go
reconfigure
go
