Thursday, April 05, 2012 8:12 AM
There is a small 3<sup>rd</sup> party company that have a small SQL Server DB. I need to import records into our instances from this DB. I thought the best way to do this would be to set up a linked server. I’ve done this internally (on the same domain), but never to an external database.
I was wondering if this was possible and what I would need to consider about permissions to their domain? I guess the linked server would use a SQL login?
Thursday, April 05, 2012 8:17 AM
I would approach in a these ways:
- option 1: ask the 3rd party to export the data and ask them to upload it to your ftp dropbox and use SSIS to import it to your DB.
- option 2: you may go with linked server but consider these security settings: put the remote SQL server behind firewall and allow only specific IP addresses to connect with SSL, or use VPN. You are right, if your domain has no trust relationship only auth mode is sql authentication.
I hope it helps.
There are 10 type of people. Those who understand binary and those who do not.
- Marked As Answer by Zoe.Ohara Thursday, April 05, 2012 11:17 AM
Thursday, April 05, 2012 8:27 AM
This may help:
SQL Server DBA
Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you
Thursday, April 05, 2012 11:18 AM
I think the SSIS way would be less of a headache really.
Cheers for your help!