Can I setup a link SQL server connection between servers on different networks?
Posted
by
Glenn Slaven
on Server Fault
See other posts from Server Fault
or by Glenn Slaven
Published on 2009-12-29T22:02:53Z
Indexed on
2012/11/04
5:06 UTC
Read the original article
Hit count: 481
We have a production SQL server hosted offsite at a hosting company, and we have a staging environment within our own network. We want to be able to setup a SQL job that copies content from a table on the staging server to prod on a regular basis, and I think we need to setup a linked server connection to do this. What do I need to get the hosting company to do to allow us to set this up? We have RDP access to the production servers, I just need to know what network and security configurations need to happen from the hosting company's perspective so I can ask them to do it.
© Server Fault or respective owner