Connecting to a remote SQL server

[bdee1]

i am hoping you guys (and gals) can help me out here. I use my SB server to host web sites but i do not have my own copy of SQL server. so i have another place that provides sql server for me. I use enterprise manager to hook up to their SQL server.

now they have a pix firewall and they set it to allow access for my server's IP address. but when i try and connect to their server it says i cant connect.

so what i am wondering is since i am using remote desktop from my home machine to access the SB server, is the firewall seeing my home machine's IP address and blocking it?

i figured it should see the traffic coming from the SB sever not my home computer.

any suggestions on how i can get my SB box to connect to this remote SQL server?

[QT]

ServerBeach had to block the standard SQL port (1433 I think) in order to stop the SQL slammer worm from infecting their network. You should change the SQL port or run your external SQL connections over a VPN or some other secure tunnel. :)