March 14, 2012 at 4:01 am
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
March 14, 2012 at 4:29 am
Duplicate post. Original topic can be found here:
http://www.sqlservercentral.com/Forums/Topic1266572-391-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply