error log 中是这个错吗? Max. number of connections reached on the server" Error 17302 (最好将error log贴出来)如是,请参考下面方法: 1. Close SQL Server Service. Then start SQL server in single user mode sqlservr -f -m 2. In Query Analyzer, execute: sp_configure 'allow updates', 1 GO RECONFIGURE with Override GO sp_configure 'user connections', 0 GO RECONFIGURE with Override GO
GoldenLion(): 用什么命令进入SQL SERVER 的单用户模式?我试了一下 SQLMANGR -F -M 还是不行啊.ErrorLog的最后一句如下: 2001-01-31 11:32:53.89 kernel The maximum limit for connections has been reached.
to enter single user mode, type "sqlservr -f -m" in command prompt. not "sqlmangr -f -m"
没有用户限制。
或使用“每服务器方式,增加授权”...
Max. number of connections reached on the server" Error 17302
(最好将error log贴出来)如是,请参考下面方法:
1. Close SQL Server Service. Then start SQL server in single user mode sqlservr -f -m
2. In Query Analyzer, execute:
sp_configure 'allow updates', 1
GO
RECONFIGURE with Override
GO
sp_configure 'user connections', 0
GO
RECONFIGURE with Override
GO
用什么命令进入SQL SERVER 的单用户模式?我试了一下 SQLMANGR -F -M
还是不行啊.ErrorLog的最后一句如下:
2001-01-31 11:32:53.89 kernel The maximum limit for connections has been reached.