Post reply

Using service accounts to connect to DB

  • July 10, 2015 at 7:30 am

    #305682

    Hi Team,

    Can I use service account to execute SSIS package, it is set as scheduled task , so hw can i set it to use service account to connect to DB in connectionstring

  • July 29, 2015 at 7:17 am

    #1815698

    Hi,

    You have to setup a proxy account (using admin credentials) to run SSIS package from Sql Agent. Refer this article for further information on Proxy account.

    You can't use proxy account to connect DB. DB connection should be established from package using package hard coded connection strings or from any one configuration method

    Hope this helps.

    Regards,

    Vijay

Viewing 2 posts - 1 through 1 (of 1 total)

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