Как запусть Agent
Доброе время суток.
На сервере стоит SQL Server 2008 Microsoft SQL Server Management Studio 10.50.1600.1 Microsoft Data Access Components (MDAC) 3.86.3959 Microsoft MSXML 2.6 3.0 6.0 Microsoft .NET Framework 2.0.50727.3607 Operating System Server 2003 R2 SP2 5.2 Запускаю SQL Server Agent через Configuration Manager выдает ошибку: "the request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." Log Date,Source,Severity,Message 10/13/2010 15:42:45,,Information,[098] SQLServerAgent terminated (normally) 10/13/2010 15:42:44,,Error,[000] Error creating a new session 10/13/2010 15:42:44,,Error,[298] SQLServer Error: 229<c/> The INSERT permission was denied on the object 'syssessions'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] 10/13/2010 15:42:44,,Error,[298] SQLServer Error: 229<c/> The UPDATE permission was denied on the object 'sysalerts'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] (DumpAndCheckServerVersion) 10/13/2010 15:42:44,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] 10/13/2010 15:42:44,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginAdmin) 10/13/2010 15:42:44,,Error,[298] SQLServer Error: 15247<c/> User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs) 10/13/2010 15:29:00,,Information,[098] SQLServerAgent terminated (normally) 10/13/2010 15:28:59,,Error,[000] Error creating a new session 10/13/2010 15:28:59,,Error,[298] SQLServer Error: 229<c/> The INSERT permission was denied on the object 'syssessions'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] 10/13/2010 15:28:59,,Error,[298] SQLServer Error: 229<c/> The UPDATE permission was denied on the object 'sysalerts'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] (DumpAndCheckServerVersion) 10/13/2010 15:28:59,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] 10/13/2010 15:28:59,,Error,[298] SQLServer Error: 229<c/> The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access'<c/> database 'msdb'<c/> schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginAdmin) 10/13/2010 15:28:59,,Error,[298] SQLServer Error: 15247<c/> User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs) Прова администратора, запускал на другой системе, то же самое. В чем может быть проблема? |
Цитата:
|
Цитата:
|
подключитесь к серверу под учетной записью SA и повторите запуск агента.
|
выдает тужу ошибку.
|
Хм. Такое впечатление, что либо пропали права доступа к папке с базами, либо ктото урезал права SA(посмотрите его роли, если можете), либо повреждена база данных msdb
|
На двух пк проверял та же байда.
Если отключить службу SQL Server (SQLEXPRESS) в SQL Server Configuration Manager, то SQL Server Agent (SQLEXPRESS) запускается. |
Время: 12:11. |
Время: 12:11.
© OSzone.net 2001-