sql server connect: I have a client with two Perl CGI intranet database applications that
have been working successfully for over a year.
Each one runs on the same IIS6 server and connects to a different
database within the same SQL Server on a different machine using the same
SQL user.

Recently (within the last month) BOTH of these applications now fail to
connect their respective databases.
Nothing in the code or connection strings has changed.

Access to the SQL databases from a local MS Access database on the IIS
server using a DSN with the same SQL user + password succeeds.

As the 1st activity in the applications is to connect to the database
(which fails) to verify username+password from a cookie there is very
little debugging that can be done from within the applications.

As far as the IT support staff can tell the only recent change was the
addition of some machines to existing domains.

Can anyone suggest what may have caused this to suddenly start failing
or suggest how to diagnose where the problem occurs?


Any help would be greatly appreciated.

leonardo616 <mikeDOTtrotmanATblueyonder.co.uk> wrote in
news:Xns9889A0208232Cmiktro@207.46.248.16:

[quoted text, click to view]

I forgot to post the connection string details being used in case it helps
track the problem down:

Provider=SQLOLEDB;
Password=<password>;
User ID=<userid>;
Data Source=<ip address>;

leonardo616 <mikeDOTtrotmanATblueyonder.co.uk> wrote in
news:Xns9889A0208232Cmiktro@207.46.248.16:

[quoted text, click to view]

Problem solved.

Somehow the password for the SQL User had been reset in SQL Server !!!!