Unable to connect MS SQL server 2008 Remote Server through SQUID proxy server

samank75 · 01-18-2012, 10:50 PM

Hi,

My computer connected to SQUID proxy server & I can access Internet, Email through this proxy server. My computer OS is Windows 7. I installed SQL server 2008 R2 on my computer. I need to connect our Remote sql server 2008 R2 Hosting server. But I cant connect to that server. How I configure My squid proxy server to access SQL server ????

Ser Olmy · 01-19-2012, 04:54 PM

It's not entirely clear what you're trying to do, but if you're trying to connect to a remote MSSQL server with Management Studio, you generally can't do that through Squid.

samank75 · 01-19-2012, 09:33 PM

Thanks for Reply.

Yes you are correct. I need to connect to a remote MSSQL server with Management Studio. Why can't configure SQUID to access Remote MSSQL server ? Please help me this is URGENT...
I try PING my remote hosting IP, But I can't too. I used 202.xxx.xxx.xxx,25000 IP & port connect to remote MSSQL server using Management Studio.

Ser Olmy · 01-19-2012, 09:59 PM

Squid is usually set up as a HTTP/FTP proxy. The protocol used by Management Studio is neither.

Squid also supports SOCKS (which can be used to proxy just about any protocol), but Management Studio has no proxy settings. It is possible to "socksify" an entire OS by installing a low-level driver, but I know of no such software for Windows.

Your best bet is to use a regular (NATed) Internet connection.

samank75 · 01-19-2012, 10:14 PM

Can I fix this issue using ISA proxy server ?

Ser Olmy · 01-19-2012, 10:19 PM

That's a bit overkill, don't you think? I can't really say if that would be a good solution or not, as I don't know anything about your network.

If the proxy is currently connected to both your internal network and the Internet, replacing it with a firewall (like ISA Server) would work. But then so would typing a single iptables command.