troubleshooting Question

Classic ASP/SQL Server Connection Issue

Avatar of Bob Schneider
Bob SchneiderFlag for United States of America asked on
ASPMicrosoft SQL Server 2008Windows Server 2008
5 Comments5 Solutions1168 ViewsLast Modified:
Sorry for posting this again but I thought it was solved...it is recurring.  Please note that these errors appear to occur at high volume times on my site.  Most of the time there is no problem but we are going to be having a busy year and I want to get this resolved.

Here are the two errors that I get:

Description: Cannot open database "xxxx" requested by the login. The login failed.
Err #:
Com Err #: -2147467259
Category: Microsoft SQL Server Native Client 10.0

And

Description: Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Err #:
Com Err #: -2147467259
Category: Microsoft SQL Server Native Client 10.0

I have other sites with another database that NEVER gets this error even when the site activity is high.  I realize that they may be related or not but I really need them both solved.  My suspicion is that it is a db setting but  may be an iis 7.0 or asp setting as well?

Thanks so much, and please remember that the site works very well most of the time!
ASKER CERTIFIED SOLUTION
Danny_De_Schutter

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 5 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros