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?
Can not connect to SQL localhost, but used to be able to
Moderator: General Moderators
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England
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?
Do you know of some firewall setting I need to tweak in order to get this back in working order?