connecting to remote server using dns name and password through ssis package in a sql server job

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Yelena Varshal SSC-Dedicated Points: 34287 More actions · Answer 1

Hi,

The solution is:

1. Create local Windows accounts with the same user name /password on both servers if they are not in the same or trusting domains.

2. In your SQL Server on Server1 for example start SQL Server Agent on this local account that you created in step 1

3. In your job specify fully qualified path to the remote folder as \\Server2\MyShare

4. Give the Server 2 user that you created in step 1 permissions to the folder on Server 2

It should work. This is how they did it in the workgroups.

Let me know if you need more help

Regards,Yelena Varsha

rrv Old Hand Points: 319 More actions · Answer 2

thanks for the reply but when you say specify the path in the job

when do i need to do that

Yelena Varshal SSC-Dedicated Points: 34287 More actions · Answer 3

It is where you say you map an SSIS package to the folder. Just map it not as X:\MyShare but as \\Server2\MyShare

Regards,Yelena Varsha