SSIS Proxy Credential Ignored

Saransvan 106 Reputation points
2021-02-04T13:06:02.697+00:00

If I run a SSIS package through a SQL Agent job using a runas SSIS proxy account the package doesn't work - fails with a required connection (which it has permissions to).

However, if I run SQL Agent using the same account as the proxy and choose SQL Agent runas in the SSIS job step, it all works.

Package works if run manually from the same account as well.

It just doesn't seem to be picking up the proxy credentials, can anyone suggest why please?

SQL version is 2016 Microsoft SQL Server 2016 (SP2-CU14)

Thanks.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2021-02-05T02:55:52.54+00:00

    Hi @Saransvan ,

    May I know if you create credential firstly?
    If no, please create it. We can refer to the following links and pictures:

    1.Create a Credential
    Credentials provide a way to allow SQL Server Authentication users to have an identity outside of SQL Server.

    2.Create a SQL Server Agent Proxy
    A SQL Server Agent proxy account defines a security context in which a job step can run. Each proxy corresponds to a security credential.

    3.How to: Configure an SSIS Package to Execute as a Proxy Account

    64337-newcredential.png

    64363-newproxy1.png

    64304-newproxyaccount.png

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Saransvan 106 Reputation points
    2021-02-05T08:55:24.717+00:00

    Obviously yes I have created a credential, as per the title of the question.