Error: 18456

Last Post 11 Mar 2009 07:08 AM by dlcooklhs. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
trans53
New Member
New Member

--
22 Jan 2009 03:09 PM


We are having this weird problem where maybe once or twice a day we are getting this error in sql error log.
I was trying to run profiler to see which application is trying to connect but when this happens the application column is blanc.
The problem is that this sql login used all the time for this database and i can't say that the password is invalid.
But somehow we are getting this error.

Any idea/suggestions what else i can use to catch where it's coming from?

Thanks


Error: 18456, Severity: 14, State: 8.
Login failed for user 'login'. [CLIENT: xx.xx.xx.xxx]
trans53
New Member
New Member

--
24 Jan 2009 01:24 PM
yes, but not always, very hard to find where the problem is.
dlcooklhs
New Member
New Member

--
11 Mar 2009 07:08 AM
Am having similar problem on SQL2005 sp2 and sp3. Crystal Reports running on server B using SQL account to connect to server C, the reports run okay, but ERRORLOG on C has multiple "Error: 18456, Severity: 14, State: 8"

Have ran " sp_change_users_login 'update_one', 'ReportUser', 'ReportUser' " for databases involved in reports

Server C security event log looks normal.

Only this SQL account and only form server B is having this problem.

This has had me stumped for months.

Am having same problem with multiple sql accounts on another server, but that is for another day.
You are not authorized to post a reply.

Acceptable Use Policy