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: 447

Filed under:
|
|

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

Related posts about sql-server

Related posts about database