【现象】
sql server登陆报错
查看ERRORLOG
2015-05-13 11:46:53.74 spid27s Recovery is writing a checkpoint in database 'mengniumiddle_sh' (7). This is an informational message only. No user action is required.
2015-05-13 11:46:53.75 spid7s Recovery is complete. This is an informational message only. No user action is required.
2015-05-13 11:46:54.64 spid52 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2015-05-13 11:46:54.64 spid52 Using 'xpsqlbot.dll' version '2007.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2015-05-13 11:46:54.73 spid52 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2015-05-13 11:46:54.73 spid52 Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2015-05-13 11:46:54.76 spid52 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2015-05-13 11:46:54.76 spid52 Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2015-05-13 11:47:00.95 登录 错误: 17809,严重性: 20,状态: 3。
2015-05-13 11:47:00.95 登录 Could not connect because the maximum number of '5' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [客户端: 172.20.52.12]
2015-05-13 11:47:01.02 登录 错误: 17809,严重性: 20,状态: 3。
2015-05-13 11:47:01.02 登录 Could not connect because the maximum number of '5' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [客户端: 172.20.52.12]
2015-05-13 11:47:01.13 登录 错误: 17809,严重性: 20,状态: 3。
2015-05-13 11:46:53.75 spid7s Recovery is complete. This is an informational message only. No user action is required.
2015-05-13 11:46:54.64 spid52 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2015-05-13 11:46:54.64 spid52 Using 'xpsqlbot.dll' version '2007.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2015-05-13 11:46:54.73 spid52 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2015-05-13 11:46:54.73 spid52 Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2015-05-13 11:46:54.76 spid52 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2015-05-13 11:46:54.76 spid52 Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2015-05-13 11:47:00.95 登录 错误: 17809,严重性: 20,状态: 3。
2015-05-13 11:47:00.95 登录 Could not connect because the maximum number of '5' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [客户端: 172.20.52.12]
2015-05-13 11:47:01.02 登录 错误: 17809,严重性: 20,状态: 3。
2015-05-13 11:47:01.02 登录 Could not connect because the maximum number of '5' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [客户端: 172.20.52.12]
2015-05-13 11:47:01.13 登录 错误: 17809,严重性: 20,状态: 3。
2015-05-13 11:47:00.95 登录 错误: 17809,严重性: 20,状态: 3。
2015-05-13 11:47:00.95 登录 Could not connect because the maximum number of '5' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [客户端: 172.20.52.12]
2015-05-13 11:47:01.02 登录 错误: 17809,严重性: 20,状态: 3。
2015-05-13 11:47:00.95 登录 Could not connect because the maximum number of '5' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [客户端: 172.20.52.12]
2015-05-13 11:47:01.02 登录 错误: 17809,严重性: 20,状态: 3。
【解决】
EXEC sp_configure 'show advanced option', '1' //只有这个高级选项被打开的时候,才有权限修改其他配置。
go
RECONFIGURE //运行RECONFIGURE语句进行安装,也就是说,使以上语句生效
go
sp_configure 'user connections','2000' //
go
RECONFIGURE
go
go
RECONFIGURE //运行RECONFIGURE语句进行安装,也就是说,使以上语句生效
go
sp_configure 'user connections','2000' //
go
RECONFIGURE
go
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30060321/viewspace-1653549/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30060321/viewspace-1653549/