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

Posted on 2012-09-13
Last Modified: 2012-09-19

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.

"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.
Question by:keplan
    LVL 28

    Accepted Solution

    I found this article that describes the situation and error you're receiving:

    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?

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
    The viewer will learn how to back up with the free utility from runtime software, DriveImageXML using Windows 7. Download DriveImageXML from Open folder where it was saved: Start installation by double clicking the install scrip…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now