Avatar of Bob Schneider
Bob Schneider
Flag for United States of America asked on

Classic ASP/SQL Server Connection Issue

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!
Microsoft SQL Server 2008ASPWindows Server 2008

Avatar of undefined
Last Comment
Danny_De_Schutter

8/22/2022 - Mon
SOLUTION
Scott Fell

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Dave Baldwin

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Scott Fell

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Anthony Perkins

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Danny_De_Schutter

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61