I have a job that I create on every SQL Server I manage that cycles the error log weekly, using sp_cycle_errorlog. Just a standard job I use everywhere. I noticed when I stated doing SQL 2008 servers that it now fails, where it runs perfectly on SQL 2005. The error I receive is:
COVAPLCES-MSQ02-Job: CycleErrorlog. Step= CycleErrorlogMessage Executed as user: dbo. User does not have permission to perform this action. [SQLSTATE 42000] (Error 15247). The step failed.
I'm out of ideas as to why this would happen, as the SQL Server and Agent run under the same domain account, which is an admin on the server and a sysadmin on the SQL Server. I have no proxies set up or anything in the "Run As" for that job step. The job owner is "SA".
I imagine this is some kind of security change for SQL 2008 but I have had no luck in finding out what it is, or what I can do about it.
Ideas welcomed.
Thanks,
Chris |