So I have 2 SQL servers, both internal on the firewall, and my webserver is on the DMZ. The webserver currently connects to one of the SQL servers for it's data.
I need some information from the other SQL server which I cannot connect to from the DMZ because of security risks that the company is not willing to take.
How can I connect to one SQL server to another to obtain certain information for particular rows in a database on the first?
So basically what I need to do is:
Server 1 has database "db1" which has a table "tbl" with fields "field1,field2,field3"
I need to populate "field3" from data obtained from Server 2 using a query.
Is this possible?
If not, how else can I do it?
Take a look at linked servers.