question

GregBooth-2902 avatar image
0 Votes"
GregBooth-2902 asked ·

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-generalsql-server-integration-services
10 |1000 characters needed characters left characters exceeded

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

OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered ·

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

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

Monalv-msft avatar image
0 Votes"
Monalv-msft answered ·

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

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

Hi @GregBooth-2902 ,

May I know if you have anything to update?

Best Regards,
Mona

0 Votes 0 ·