After SP4 I got 'no such interface supported' in snapshot agent

Hi All,
After SP4 I cannot run merge replication.
Snapshot agent try 10 times to start and on the end
give me a message 'No such interface supported. blalblabla'.
Do You have suggestion ?
Regards,
Tomasz Skorupa
Hi Tomasz,
Assuming you were talking about SQL2000 SP4, such errors can typically be
resolved by doing the following:
regsvr32 "%PrograFiles%\Microsoft SQL Server\80\COM\replagnt.dll"
"%PrograFiles%\Microsoft SQL Server\80\COM\snapshot.exe" /RegServer
"%PrograFiles%\Microsoft SQL Server\80\COM\logread.exe" /RegServer
"%PrograFiles%\Microsoft SQL Server\80\COM\distrib.exe" /RegServer
"%PrograFiles%\Microsoft SQL Server\80\COM\qrdrsvc.exe" /RegServer
"%PrograFiles%\Microsoft SQL Server\80\COM\replmerg.exe" /RegServer
If the above didn't resolve the issue, you may want to check the version of
sqlrepss.dll in the Binn directory of your sql server instance. (Post the
version number here if you don't know whether it looks right or not.)
Now even if you manage to resolve the issue, the bigger mystery here is why
you managed to get your machine in the current state in the first place. It
would be great if you can let us know of any recent unusual activity on the
machine that might have led to the problem. For example, were there any error
messages when you ran the SP4? Have you ever install SQL2005 on the machine
(note: SQL2005 express comes with VS2005 beta also)?
-Raymond
"Tomasz Skorupa" wrote:

> Hi All,
> After SP4 I cannot run merge replication.
> Snapshot agent try 10 times to start and on the end
> give me a message 'No such interface supported. blalblabla'.
> Do You have suggestion ?
> Regards,
> Tomasz Skorupa
>
>
|||Hi Raymond,
First of all, thank You for Your support.
"Raymond Mak [MSFT]" <RaymondMakMSFT@.discussions.microsoft.com> wrote in
message news:E827B5F7-D25A-40B0-AF97-B4D461395139@.microsoft.com...
<...>
> Assuming you were talking about SQL2000 SP4
Yes of course.

> resolved by doing the following:
<...>
> "%PrograFiles%\Microsoft SQL Server\80\COM\replmerg.exe" /RegServer
I have the same problem on other machine with similar software and hardware
configuration.
I reregister this files on both but it not correct problem.

> If the above didn't resolve the issue, you may want to check the version
> of
> sqlrepss.dll in the Binn directory of your sql server instance. (Post the
> version number here if you don't know whether it looks right or not.)
It is 2000.80.2039.0 on both computers.

> Now even if you manage to resolve the issue, the bigger mystery here is
> why
> you managed to get your machine in the current state in the first place.
> It
> would be great if you can let us know of any recent unusual activity on
> the
> machine that might have led to the problem. For example, were there any
> error
> messages when you ran the SP4? Have you ever install SQL2005 on the
> machine
> (note: SQL2005 express comes with VS2005 beta also)?
Our last install before SQL SP4 was MS Virtual PC.
On virtual pc we have SQL Server 2005 and Visual Studio .Net 2005
(Technology Preview).
On both computers SP4 was installed without any error or warning message.
Regards,
Tomasz Skorupa