Re: What causes a working connection to fail?

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

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.

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.


Leo


Problem solved.

Somehow the password for the SQL User had been reset in SQL Server !!!!
Restoring original password fixed the problem.
.

Relevant Pages
Loading