SQL Server Performance Forum – Threads Archive
EXECUTE permission denied on sp_start_jobwE have to execute a job and part of the job is to start job on another server. Both the servers are mapped as linked servers and we can easily access them and query them However when this job executes, it comes up with error message give below. Interesting part is if I excute this step in query analyzer, it runs fine, but as a part of job it fails with below mentioned error message. Executed as user: PATCHSQLEXECACCOUNT. EXECUTE permission denied on object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000] (Error 229). The step failed. "PATCHSQLEXECACCOUNT" is domain admin on both servers and also sysadmin on both servers. Also since this is windows login, password and all other information is same for this login. I have specifically given execute permissions as well on sp_start_job on both server, for this account. However I am still getting the same error message. Any ideas why this is failing??
What securiy context you are using? did you try "Impersonate" option in Linked Server Properties (Security Tab) MohammedU.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
See this FAQhttp://sqljunkies.com/WebLog/ktegels/archive/2006/11/09/25306.aspx and ensure to add them on newly available SQLagent roles. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.