在AD上安装sql2005,没有遇到任何问题,安装virtualserver2005 后重启电脑,发现好几个问题
问题1:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17187
Date: 6/22/2009
Time: 6:03:03 PM
User: N/A
Computer: BORCH-CRM
Description:
SQL Server 尚未准备就绪,无法接受新的客户端连接。请等几分钟后重试。如果您有权访问错误日志,请在找到说明 SQL Server 已准备就绪的信息性消息后,再重试连接。 For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 23 43 00 00 10 00 00 00 #C......
0008: 0a 00 00 00 42 00 4f 00 ....B.O.
0010: 52 00 43 00 48 00 2d 00 R.C.H.-.
0018: 43 00 52 00 4d 00 00 00 C.R.M...
0020: 00 00 00 00 ....
解决办法:
让sqlserver启动后再启动virtualserver ,如果virtualserver前于sqlserver 就会出现问题
修改注册表,使virtualserver依赖sqlserver启动
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\virtualserver
编辑DependsOnService 的值,给REG_SZ_MULTI 增加值
MSSQLSERVER
SQLSERVERAGENT
重启后,解决sqlserver 17178 问题
问题2:
Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: 管理
Event ID: 107
Date: 6/23/2009
Time: 2:06:58 PM
User: N/A
Computer: BORCH-CRM
Description:
Report Server Windows Service (MSSQLSERVER) 无法与报表服务器数据库建立连接。
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
在SQL server 2005中设置SQL Server Configuration Manager的SQL server 2005服务中的启动设置为’自动‘;并设置状态为 启动。