Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 SQL Server Express and proxies

Author  Topic 

fonzi
Starting Member

2 Posts

Posted - 2007-12-13 : 10:12:12

I want to know how I get SQL Server Express to use a proxy when connecting to a remote server?
I have SQL Server Express 2005 installed on my laptop.I connect to the internet on the laptop by a proxy.
My desktop has a satellite service called skyDSL which allows me to use satellite to dial-up to the internet. There is a way of configuring it so other machines can connect to it by proxy. You simply connect a crossover cable between the laptop and the desktop and then enter the proxy address under "Tools-Internet Options-Connections-Lan Settings-proxy server"
I have been trying to connect on the laptop to the server that holds my sql server database (hosting365.ie) through SQL Server Express with no success.
This is obviously because the laptop is not directly connected to the internet but by proxy.
I have been changing the settings on sql server configuration manager (I have SQL Server Management Studio Express installed) to make it use the proxy but with no luck.
I am wondering is it actually possible to use a proxy on SQL Server Express is it only possible on the full version?
Any replies appreciated.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-13 : 23:41:25
Is sql port open on firewall?
Go to Top of Page

fonzi
Starting Member

2 Posts

Posted - 2007-12-14 : 12:29:43
I think I actually disabled the firewall to make sure it wasn't the problem. I'll check again though.
Go to Top of Page
   

- Advertisement -