SQL Server at ISP

[mdr227]

I have a SQL server database with a hosting plan at Interland. I can connect fine to their SQL Server from home on my portable, but when I take my portable to work I cannot connect to it. Interland tells me that I need to make sure port 80 is open on our network. We do not run a firewall at work, only use a router/hub to connect to the Internet gateway at my employer. Does anyone know what I can check to see if this port is being blocked?

 

[mrdenny]

SQL doesn't listen on port 80, it listens on port 1433. Your ISP may be blocking this port. Do you have to connect to there web based managment page, or directly to the SQL Server via Enterprise Manager?

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[mdr227]

You are right, I meant port 1433. The ISP is not blocking it because I can connect fine on my portable from home using DSL. At work with the same portable I have the problem.

 

[ecobb]

Are you using the same ISP service at home that you're using at work? Different Internet Services could have different port settings.




Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[mrdenny]

mdr,
The ISP that I was referring to was the ISP at work. Open a command prompt while at work and type;

telnet {sqlservers_IP_Address} 1433

If you get a blank window with a flashing cursor then you connected. If you get an error message then the connection was blocked somewhere down the line.

Have someone check if there are any ACLs on the router. They can block the connection. Have someone check with your works ISP and see if they are blocking your connection on there routers. Depending on who your works ISP is, you may need to check with them. Any one of these companies can be blocking the connection and any one of the routers between you and your hosting company and screw things up.

It's probably your works ISP. Many business ISPs block access to port 1433 in and out of there network to prevent things like SQL Slammer and brute force SQL attacks from going through there network.

Denny

--Anything is possible. All it takes is a little research. (Me)