question

GregBooth-2902 avatar image
0 Votes"
GregBooth-2902 asked Monalv-msft edited

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
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

2 Answers

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


5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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 Monalv-msft edited

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
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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 Monalv-msft ·

Hi @GregBooth-2902 ,

May I know if you have anything to update?

Best Regards,
Mona

0 Votes 0 ·