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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 ?
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
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.