Connect to MS SQL on different subnet
Posted on 2004-10-11
I have a remote hosting environment which includes two machines - a web server and an ms sql server. The sql machine uses an internal IP 192.168.0.10 and the web server has a real IP as well as an internal IP (used to connect to sql server). Using this setup its not possible to ping or connect to the sql machine remotly. Is it possible to somehow setup a way to connect to the sql server via either Enterprise manager or Query Analyzer remotely?
If this is not possible is there any other way I can connect to it? I have full control of both machines so I can make any needed changes.