I need to create a sql server integration services job that transfers files from one domain to another. So it will need access to fileshares on two domains. How do i do this.

Greg Booth 1,276 Reputation points
2021-02-22T18:00:13.233+00:00

I need to create a sql server integration services job that transfers files from one domain to another. So it will need access to fileshares on two domains. Files will appear (due to user actions) on a folder in a fileshare on Domain A. The SSIS job will run from a server on domain B - and the job needs to be able to read the files from domain A - and transfer them to domain B. The SSIS sql agent job runs (by default) using a domain account for domain B. How do i grant that account to be able to access fileshares in Domain A ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,629 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,656 Reputation points
    2021-02-23T06:37:30.69+00:00

    How do i grant that account to be able to access fileshares in Domain A ?

    That's nothing SQL Server related, but to Windows AD, so better change the tagging of your post.
    Head out for trusted domains & forest: Forest Design Models

    1 person found this answer helpful.
    0 comments
  2. Monalv-MSFT 5,891 Reputation points
    2021-02-23T09:55:56.16+00:00

    Hi @Greg Booth ,

    In this article we look at the methods used for working with SQL Server data, and use of file shares to support delivery of production databases with containers.

    Please refer to the following links:
    How to use Windows hosted file shares to support SQL Server containers
    How to access shared files in two different domains

    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.