Home  >  Article  >  Database  >  SQL SERVER 2000 迁移后SQL SERVER代理服务启动错误分析

SQL SERVER 2000 迁移后SQL SERVER代理服务启动错误分析

WBOY
WBOYOriginal
2016-06-07 17:39:041457browse

2013-09-20 09:46:12 - ! SQLServer 错误: 229,EXECUTE permission denied on object 'sp_sqlagent_has_server_access', database 'msdb', owner 'dbo'. (ConnIsLoginSysAdmin) 2013-09-20 09:46:12 - ! SQLServer 错误: 229,EXECUTE permission denied on

2013-09-20 09:46:12 - ! SQLServer 错误: 229,EXECUTE permission denied on object 'sp_sqlagent_has_server_access', database 'msdb', owner 'dbo'. (ConnIsLoginSysAdmin) 2013-09-20 09:46:12 - ! SQLServer 错误: 229,EXECUTE permission denied on object 'sp_sqlagent_get_startup_info', database 'msdb', owner 'dbo'. 2013-09-20 09:46:12 - ? Microsoft SQLServerAgent 8.00.2039 版(内部版本号 x86 unicode retail): 进程 ID 2013-09-20 09:46:12 - ? Microsoft SQLServerAgent 8.00.2039 版(内部版本号 x86 unicode retail): 进程 ID 796 2013-09-20 09:46:12 - ? SQL Server 8.00.2039 版(0 连接限制) 2013-09-20 09:46:12 - ? SQL Server ODBC 驱动程序 3.85.11172013-09-20 09:46:12 - ? 正由驱动程序使用的 NetLib 是 DBMSSHRN.DLL;本地主机服务器是 2013-09-20 09:46:12 - ? 检测到 2 个处理器和 2048 MB RAM 2013-09-20 09:46:12 - ? 本地计算机是 GETHRTESTW2KS,,运行 Windows NT 5.0 (2195) Service Pack 4 2013-09-20 09:46:12 - ! SQLServerAgent 必须可以以 SysAdmin 身份连接到 SQLServer,但是“(未知)”不是 SysAdmin 角色的成员 2013-09-20 09:46:13 - ? SQLServerAgent 已终止 (正常)

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn