TwoThrones
13-10-2010, 15:49
Доброе время суток.
На сервере стоит 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)
Прова администратора, запускал на другой системе, то же самое.
В чем может быть проблема?
На сервере стоит 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)
Прова администратора, запускал на другой системе, то же самое.
В чем может быть проблема?