hi everyone.
I have a web application on ServerN that needs to access data from SQL Server 2000 db on ServerD over the Internet. However, for security purposes, ServerD is not allowed Internet access. Therefore, there is a ServerM on same LAN as ServerD. ServerM has Internet access; and can connect over the lan to ServerD.
I would like to install SQL Server 2000 on ServerM, and do a link to the db on ServerD. Therefore, ServerN would send requests to ServerM. ServerM send data from ServerD back to ServerN.
Do I need middleware software on ServerM to make this happen? If yes, please give me some names. If no, how do I do it.
Thanks. T