I am taking full advantage of my subscription with these issues lately. I have scoured the web and I can find NO REFERENCE to why I would be getting this error SPORADICALLY (there are tons of references where this issue comes up but not on a sporadic basis that I have seen):
Cannot open database "xxx" requested by the login. The login failed.
It happens here: www.gopherstateevents.com
and it happens with this connection string/ query:
Set conn = Server.CreateObject("ADODB.Connection")
sql = "INSERT INTO Visitors (When_Visit, Page, IPAddress, Browser) VALUES ('" & Now() & "', 'default', '"
sql = sql & Request.ServerVariables("REMOTE_ADDR") & "', '" & Request.ServerVariables("HTTP_USER_AGENT") & "')"
It also happen in other places but, again, SPORADICALLY. I am reasonably certain that the user has correct permissions and I don't even thing it is typically a high volume error.