Can not connect to SQL localhost, but used to be able to
Posted: Sun Dec 12, 2004 12:03 am
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?
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?