Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Folder Permission issue

Author  Topic 

sarahmfr
Posting Yak Master

214 Posts

Posted - 2011-09-11 : 12:12:52
I have an ssis package that exists on machine A (SQL server) that receives xml files from another system
the files are sent to a machine B (that does not have sql installed on it) the bad thing is that the two machines A and B are not in a domain.
They use virtual machines which are not in a domain
So how to give sql server agent from machine A access to a folder on machine B
Do you think that I added on machine B an account having the same name as sql server agent and same password and let it act as a service will that work.

This is a continuation to another question that I posted before when one of your experts suggested to ask the network admin to give sql server agent access to machine B I am posting this question now because I understood from our admin that Machine A and Machine B are not in the same domain.


Thanks

sarah
   

- Advertisement -