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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
tdelobe
Forum Commoner
Posts: 41
Joined: Thu Aug 07, 2003 2:28 pm
Location: washington, dc

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

Post 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?
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post 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?
tdelobe
Forum Commoner
Posts: 41
Joined: Thu Aug 07, 2003 2:28 pm
Location: washington, dc

Post 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?
Post Reply