Share via

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

Praveen Channal 1 Reputation point
2020-09-24T11:19:48.797+00:00

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

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,067 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,486 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,577 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2020-09-25T01:58:37.88+00:00

    Hi @Praveen Channal ,

    Please do as the following steps:
    1.Create new credential
    28099-createcredential.png

    2.Create new proxy
    28129-createaproxy.png

    3.Run the job using proxy
    28192-runasaproxy.png

    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.