Can I connect to a SQL Server that is external to my network?

I'm not sure if this is possible.

My office Pc sits on the corporate network and to access anything outside this network I have to provide my username and password to get though the proxy.

We have recently purchased a hosted server external to this network so that we can host demo applications that can be access from anywhere. Ho开发者_如何学运维wever when we need to connect to the server to update or work on the database we need to use a PC that is not on our network as there is no way to provide my username and password as either part of a connection string or in the management console.

The external server is running SQL Server 2008.

Any advise would be much appreciated as I'm not sure if this is even possible.

Thanks!

You can create an http tunnel between the server and the computer from which you want to access the SQL server. Use HTTPtunnel GNU package for the organization HTTP tunnel. Here an example of a HTTP tunnel to connect to the MySQL server. To connect to SQL server you must specify the appropriate port.

try to use TeamViewer. 1. Installed on the server TeamViewer ... during the installation process specify a fixed password for remote access. remember or write ID (9 digits) 2. on your work computer install teamviewer. connect to remote server ID and password.