SqlServerAgent启动问题

在英文windows server2000+sp3、中文企业版sql server2000+sp3环境下,agent启动不了。其他sql服务启动正常。发生在安装sql server2000 的sp3后,之前正常。一直用administrator启动,未改过密码,帐号换成localsystem也不行。event viewer中,相关错误提示如下:
(1)SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).
(2)错误: 823,严重度: 24,状态: 2
I/O error 23(error not found) detected during read at offset 0x00000000b80000 in file 'd:\MSSQL\data\msdbdata.mdf'.
难道是msdbdata.mdf有问题,怎样解决?请赐教,谢谢!

---------------------------------------------------------------

你先用 dbcc checkdb 检查一下 msdb 数据库,如果没有错误,再检查这个服务的启动用户的权限及密码的问题。

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus