Hi

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

Many Thanks

D

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

There was apparently an as yet not fully explained registry ACLing problem in
SP4 setup per the following thread (reported by Tomasz Skorupa originally):

http://groups.google.com/group/micro...85 a5a37097d4

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?

-Raymond Mak


"DJ" wrote:

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
anything else?

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?

Many Thanks

Daryl

"Raymond Mak [MSFT]" wrote: