April 21, 2011 at 8:50 am
Hello,
I have problems with jobs that were started by the SQL Agent on SQL Server 2008R2 since i have changed the used SQL Server Agent User for all instances to different users. I have followed this website http://msdn.microsoft.com/en-us/library/ms143504.aspx to give the users the appropriate rights. I have also used this site for help: http://blogs.msdn.com/b/varun_sharma/archive/2007/08/30/how-to-run-sql-server-agent-and-sql-server-jobs-with-least-privilege-in-sql-server-2005.aspx
Afterwards the SQL Server Agent has started on all instances. But there are still several messages about failed jobs.
I checked the Windows Application Log, got the message "package...failed" (eventID 12291).
Or in the history of the job, got the message "The job failed. The Job was invoked by Schedule 4 (CollectorSchedule_Every_15min). The last step to run was step 2 (collection_set_2_upload_upload)."
I think that there still must be a permissions problem.
Almost all jobs are collecting information of the databases in the instance and they are uploading the data to the standard MSSQLServer instance. But even in the standard instance the job fails.
Now i don't know whether I have don’t set all needed permissions, or do I have to change s.th. on the roles of msdb (I’ve read that it should be done, maybe?) or do i have to make credentials/proxies so that the jobs work well again?
thank you for your help.
May 2, 2011 at 7:20 am
Hello,
I have monitored the same problem on an other server with the existent User. This user was used by the installation of the SQL Server.
Normally the Sql Server should give than the necessary rights. But somehow the jobs get the same errors like described.
Can anybody help? Thanks.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply