SQL 2008 ssis not running jobs with proxy account on 2 node cluster error1314

Question

SQL 2008 ssis not running jobs with proxy account on 2 node cluster error1314

derek.mclaren

SSC Veteran

Points: 270
More actions
March 14, 2012 at 3:53 am

#270011

Hi All
We have a 2 node Windows server 2008 sp2 and SQL 2008 sp3 10.0.5500.0 cluster. Ssis is installed as a service on the cluster and we can connect to it and see all the packages. We also have setup a login, a credential and a proxie account to run ssisjobs. We do not want to run these jobs using the sql agents as we have security issues. The above mentioned account is a domain account and has been added to all the required groups in windows ie. log on as batch service, replace token, dcom user etc.
the problem however is that we can run a ssisjob using the sqlagent account no problems BUT when why try and use our proxy account webssisprodproxy we get the error:
Message
Executed as user: DOMAIN\WebSsisProd. The process could not be created for step 1 of job 0x9FECE76BCD76674DB96BD4513C58EB9C (reason: 1314). The step failed.
The login is : domain\webssisprod
The credential is : webssiscred
the proxy is: webssisproxy
The package works using the sql agent but not our proxy account.
Please ANY HELP would be HIGHLY APPRECIATED.
Thanks
Derek

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Is it possible to log into the server as that proxy account and try to execute the package manually?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 2

Check the privileges allocated to the two accounts (WebSSISProxy and SQL Agent Services account). To get the result as shown privileges are missing from the WebSSISProxy. Which permissions / privileges depend on the task(s) thats are running.

derek.mclaren SSC Veteran Points: 270 More actions · Answer 3

Hi

I can log in to the server using ssms but then i can not see the sql server agent tab where the job is, but however i can log in with the account to integrated services and from there i can run the job.

The job is stored on the file system and not msdb. \\servername\packages\ssistest .

derek.mclaren SSC Veteran Points: 270 More actions · Answer 4

I made the webssisprod domain account a db owner,data reader and data writer on one db just to test, but the package only send a test mail and it is saved with protection level DontSaveSensitive .

Thanks