New to asp and having SQL Server DB issues I can't figure out

[ptotaram]

Hey everyone

My friend's website was hacked, and I am fixing it for them, it was done in ASP and it seems to be working but afterwards I occassionally get this error, it doesn't come up everytime

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'cava'.

/LM/W3SVC/369653/Root/global.asa, line 18

Line 18 of the global.asa file is 'conn.Open Provstr'

for 2 days I've been trying to figure out what has been wrong, haven't been able to, can someone please help me?

[yamaharuss]

The error is obvious.. the login is failing. are you using a session variable perhaps for the login credentials? maybe they are expiring?? just a thought.

[ptotaram]

Well the failed login is into the db not into the site
the login info for the db is all correct, and it is still displaying data from the db on the site

[ptotaram]

I just notice the error appears when i clean my cache, but when the site is in cache, it doesn't appear anymore

[yamaharuss]

I know the login is for the db.. but where are you storing the login info? Is it hard-coded in your connection string or are you getting it from a variable?

[ptotaram]

its hardcoded