Replication Breaks after applying SP4 - 10-19-2005 , 08:36 AM
I installed SP4 on our enterprise server this morning and now all
replication jobs fail with the message "No such interface supported"
Has anyone seen this before / know how to resolve this?
We run Enterprise Edition on Win2003
Re: Replication Breaks after applying SP4 - 10-19-2005 , 08:56 AM
nope. I suggest you re-register the replication dll's and exes. I think you
can find them in c:\program files\microsoft sql server\mssql\80\com
"DJ" <DJ (AT) discussions (DOT) microsoft.com> wrote
RE: Replication Breaks after applying SP4 - 10-19-2005 , 11:59 AM
There was apparently an as yet not fully explained registry ACLing problem in
SP4 setup per the following thread (reported by Tomasz Skorupa originally):
With more than one person hitting the same problem, I would like to try
again and see if I can find out more about the cause of it. Was the user
running SP4 setup on the machine the same as the one running SQL Server Agent
service? If not, did the account running SP4 have privilege for enumerating
account information for the SQL Server Agent service account?
RE: Replication Breaks after applying SP4 - 11-01-2005 , 04:21 AM
Thanks for the reply Raymond and apologies for not replying sooner but I have
been off work.
I tried re-registering the dll following the steps you mentioned in the
other thread but this did not work for me.
I re-registered them and stopped and started SQL Agent. Did I need to do
The version of sqlrepss.dll on my instance is :2000.80.2039.0
I was not connected as the service account so I may not have had the
prvilages for enumeration the account informaion.
I can run the replication from the command line but I always get the error
when using Enterprise Manager.
Do you have any other suggestions to resolve this?
"Raymond Mak [MSFT]" wrote: