Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kenchee
Starting Member
49 Posts |
 Posted - 2010-07-13 : 23:09:37
|
Hi All, I'm getting SQL Server Agent error on my SQL 2005 SP3 CU 7 which is clustered. These are the error messages that I'm getting- (298) SQLServer Error: 18452, Login failed for user ''. The user is not associated with a trusted SQL Server connection. [SQLSTATE 28000]
- Logon to server '<sqlserver>' failed (ConnUpdateStartExecutionDate)
- (382) Logon to server '<sqlserver>' failed (JobManager)
- (382) Logon to server '<sqlserver>' failed (ConnUpdateStartExecutionDate)
- (382) Logon to server '<sqlserver>' failed (ConnUpdateJobActivity_NextScheduledRunDate)
- (382) Logon to server '<sqlserver>' failed (ConnAttemptCachableOp)
- [382] Logon to server '<sqlserver>' failed (ConnGetOperator)
The SQL Server Agent was still working well and there was no reported issues with the database however when I was checking the logs the day after for another issue I found these errors. Has anyone encountered this before and can shed some light on this? ThanksKen |
|
|
|
|
|
SQL Server Agent error with ConnGetOperator