SQL Server could not be accessed publicly!!!

[Benjie Solleza]

Could anyone help me with this? We had this web based program using SQL as database, and its running perfectly until one day..no one could accessed it anymore using the internet..even our employers based abroad (FOREIGN COUNTRY) could not accessed it either...

The previous setup of my devices from the internet is as follows: MODEM then SWITCH... then ROUTER..while the SERVER (SQL) is connected to the SWITCH..???? ..I'm pretty sure that this is the same physical layout that we had before and it ran well until lately, as i said before..we could not accessed anymore our web based program publicly....DO I NEED TO RECONFIGURE SOME DEVICES ALONG THE LINE???? PLS HELP......

[Great_One]

As always, the 1st question is what changed?

Assuming that the sql server sits internally, and the web server sits outside the firewall,
then normally a port needs to be forwarded across the router so the web app can talk to the db server. Microsoft sql is port 1433, Oracle uses 1525, and 3306 is common for mysql.
If that is how your app is setup, I would check the router and make sure that the 2 servers can communicate.

[mairving]

What kind of modem, cable or DSL? If so it's quite possible that your IP address changed. Do they access it via IP address or sitename? If by IP address make sure they are using the same one. If by sitename make sure that the DNS is pointing correctly. If you don't know your IP address go here (http://whatismyipaddress.com/)