?
Solved

Create a Service account to run SSIS packages on  SQL server 2008 Agent Services

Posted on 2012-09-13
4
Medium Priority
?
2,595 Views
Last Modified: 2016-11-15
Hi,

I've created a Service account to run the SSIS packages under SQL server Agent, But it did not work, as the jobs failed with the following error message.

Message
"Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 1).  The  step failed. "

and one things,  I've SSIS package that I've setup source connection manager on a remote server on the same domain to get the source data into my data warehouse tables.
What is the parmissions SQL server Service account should have in order to run the SSIS package without any failure.

Thanks in Advance.
Kplan
0
Comment
Question by:keplan
2 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 total points
ID: 38414353
I found this article that describes the situation and error you're receiving:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/8ca07755-0928-47d7-9e40-1aec0b24474d

Essentially, it identifies the problem as an invalid set of credentials - specifically, ones that don't contain a domain name. If you re-add the credentials using "DOMAIN\Username" format instead of just "username", does the process work?

Also, you can check the SQL Agent error log directly to get a more meaningful error, as the errors returned to SSIS in cases like this can sometimes be abstracted on unclear. Does that give any more detail?
0
 

Author Comment

by:keplan
ID: 38415909
Thanks for the answer, infact, I worked out myself to find the answer which one you advice to have domain name credential with 'DOMAIN\Username' format, that was the exactly the issue.

Thanks for answering this, excellent.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question