How to configure SQL Proxy and Credentials

1)   Open SSMS and Connect to relevant Sever

2)   Expand <ServerName> ->Security -> Credentials, Right Click On the credentials and click New Credential

 

 

      3)  Then Provide

·        proper name for credential

·        Select the User

·        Password and confirm

4)After that When expand the credential you can view the created credentials with provided   name 

 

   5) The expand the Security-> Login and right click the SA account the go to properties

    6)Go to general,Tick the Map to Credentials,after that Add the created credentials

7)Go to SQL server agent right click on the server and start the server

8)Expand SQL server agent ->Proxies->SSIS package Execution , then right click and Create new proxy account.

9)Provide relevant name and select your credential which your Provided name

 

10) Create a New job , go to steps tab and create a new Job

     Finally In Run as drop down you can see the Proxy which you created

 

Done

Thank you..