What causes a working connection to fail?



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.


Leo
.



Relevant Pages

  • Creating/Altering Database Schemas via Code
    ... to create/alter the database for a suite of ... the server in an INI file) ... I have never heard of major applications (a suite of at least 9 client ...
    (microsoft.public.vstudio.general)
  • Re: polymorphism (was: Poly Couples)
    ... but this is not really "business software"... ... Most of such applications are built as a combination of ... database with flat files or a different RDBMS vendor?" ... couldn't care less if I do it in using structured programming or OOP ...
    (comp.object)
  • Limiting applications database size
    ... I have a database server that contains several applications. ... to facilitate one-on-one interaction with one of our expert instructors. ...
    (Security-Basics)
  • Re: Unisys OS/2200 DMS / TIP / COBOL Migration
    ... support the legacy system api's that the application is using. ... differences in COBOL compiler dialects. ... What DBI does is to provide legacy database (DMS) ... the legacy database to the COBOL applications. ...
    (comp.sys.unisys)
  • Re: System Architecture / .NET Remoting
    ... application server" Also, I was trying to determine if the best way ... have no problem sharing your SOA amongst many applications. ... layer. ... ignorant of anything to do with database connections and the like. ...
    (microsoft.public.dotnet.languages.csharp)

Loading