locked
SSIS, SQL Server Agent, SQL Server Agent Service Account RRS feed

  • Question

  • SSIS2008

    Created a package in BIDS2008, deploy to SQL2008 MSDB. The package resides in DEV and function of package is go to PROD and refresh table from PROD. Works under my login (sysadmin priv in both machine) in BIDS2008.

    Created a job, run it, fails because SQL Server Agent Service Account not in PROD.

    DEV's SQL Server Agent Service Account - SQLSvcDev

    PROD's SQL Server Agent Service Account - SQLSvcProd

    So I went back to Job Step properties and "Run as:" is a dropdown and only has SQL Server Agent Service Account.

    Is there a way to change Run as? IF not, any suggestions on how do I fix this issue if adding the Service Account username (SQLSvcDev) is not an option in PROD box?

    Thanks.


    • Edited by User828 Friday, April 5, 2013 3:07 PM
    Friday, April 5, 2013 3:06 PM

Answers

All replies