Page 1 of 1

Can not connect to SQL localhost, but used to be able to

Posted: Sun Dec 12, 2004 12:03 am
by tdelobe
All the sudden none of my php or asp.net pages can make connections to my localhost sqlserver. My connection strings are fine and I used to be able to connect with no problem.

I can open Enterprise Manager and Query Analyzer and query tables, create tables, everything. SQL server is running, and the user name and passwords I have in my connection string are fine too because I used them to open Ent Manager.

Also, I have a .php page that runs fine on another server and I popped it onto my IIS server and it can't make a connection to an exterior (no the localhost) database either. This page works fine on the other IIS server.

Any idea how I can resolve this issue?

Posted: Sun Dec 12, 2004 5:36 pm
by kettle_drum
Have you added/updates or changed any software lately? Can you telnet to the port the database server is running on? Is there a firewall protecting it?

Posted: Sun Dec 12, 2004 6:45 pm
by tdelobe
I can not telnet to the port (I tried 1433, is that right?) and the only thing I can think of is that this has something to do with Windows SP2 and the Firewall that comes with it. I have tried adjusting some of the settings to windows firewall, but nothing as worked so far.

Do you know of some firewall setting I need to tweak in order to get this back in working order?