Create Credentials of the network shared access in SQL server to be used by SQL Agent

Question

Create Credentials of the network shared access in SQL server to be used by SQL Agent

Praveen Channal 1

How to create 'Create Credentials of the network shared access in SQL server to be used by SQL Agent'

Thanks

Olaf Helper 47,436 Reputation points

2020-09-24T12:24:00.47+00:00

For me it's not clear what you are lookup for, may can you explain it more detailed, please?
Praveen Channal 1 Reputation point

2020-09-24T14:56:46.22+00:00

Create Credentials of the network shared access in SQL server to be used by SQL Agent
Create Proxy to copy the file to shared path from SQL Server Agent Job using shared credential
Create SQL Agent Job 'Full File' Step1 to use the SSIS package
Create SQL Agent Job 'Full File' step 2 to Copy file from local drive to network shared path with owner as proxy credential

This is my use case . Let me know how to go about

1 answer

Your answer

Olaf Helper 47,436 Reputation points

2020-09-24T12:24:00.47+00:00

For me it's not clear what you are lookup for, may can you explain it more detailed, please?
Praveen Channal 1 Reputation point

2020-09-24T14:56:46.22+00:00

Create Credentials of the network shared access in SQL server to be used by SQL Agent
Create Proxy to copy the file to shared path from SQL Server Agent Job using shared credential
Create SQL Agent Job 'Full File' Step1 to use the SSIS package
Create SQL Agent Job 'Full File' step 2 to Copy file from local drive to network shared path with owner as proxy credential

This is my use case . Let me know how to go about

Answer 1

Monalv-MSFT 5,926

Hi @Praveen Channal ,

Please do as the following steps:
1.Create new credential

2.Create new proxy

3.Run the job using proxy

The following links will be helpful:
Create a Credential
Create a SQL Server Agent Proxy
SQL Server Agent Jobs for Packages
Running a SSIS Package from SQL Server Agent Using a Proxy Account

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.

Monalv-MSFT 5,926 Reputation points

2020-09-28T07:03:20.537+00:00

Hi @Praveen Channal ,

Please don't hesitate to contact us if you have anything to update.

Best Regards,
Mona

Share via

Create Credentials of the network shared access in SQL server to be used by SQL Agent

1 answer

Your answer