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!