Thursday, March 29, 2012

Error from Distribution clean up

Hi all,
last 9 april 2004 is occured this error:
"Event Type:Warning
Event Source:SQLServerAgent$SQLQRS
Event Category:Printers
Event ID:208
Date:4/9/2004
Time:6:10:06 AM
User:N/A
Computer:
Description:
The description for Event ID ( 208 ) in Source (
SQLServerAgent$SQLQRS ) cannot be found.
The local computer may not have the necessary registry
information or message DLL files to display messages from
a remote computer.
The following information is part of the event:
Distribution clean up: Stride3Distribution,
0xAF771833463E8642AD563AA9C8901B99, Failed, 4/9/2004
6:10:00 AM, The job failed.
Unable to determine if the owner (OTP\sysadmin19) of job
Distribution clean up: Stride3Distribution has server
access (reason: Violation of PRIMARY KEY
constraint 'PK__syscachedcredent__3F9B6DFF'.
Cannot insert duplicate key in
object 'syscachedcredentials'. [SQLSTATE 23000] (Error
2627) The statement has been terminated. [SQLSTATE 01000]
(Error 3621)).."
I need of help, someone can help me, please
EmSga
I have seen part of this error message before:
"Unable to determine if the owner (OTP\sysadmin19) of job
Distribution clean up: Stride3Distribution has server
access."
In this case you can set the job to be owned by sa and avoid the active directory lookup.
As for the rest, can you check that the sql agent running the replication job has the correct rights on the other server.
Regards,
Paul Ibison
sql

No comments:

Post a Comment