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.

Question

question

GregBooth-2902 asked · Feb 22 at 06:00 PM

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.

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-general sql-server-integration-services

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-02-23T06:37:30.69Z

OlafHelper-2800 answered · Feb 23 at 06:37 AM

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

· Share

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2021-02-23T09:55:56.16Z

Monalv-msft answered · Feb 23 at 09:55 AM

Hi @GregBooth-2902 ,

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.

· 1 · Share

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft · Feb 26 at 06:34 AM

Hi @GregBooth-2902 ,

May I know if you have anything to update?

Best Regards,
Mona

0 ·

question