Merge Replication after SQL Server SP3 - "The process was successfully stopped" error
Goran
Before we applied SP3 to our SQL Server 2000, we had a merge replication
working between our server (the publisher) and one of our client's MSDE
database (the subsciber). Our server is behind an ISA Server and we use
server publishing to make the SQL available externally on the Internet. The
server was/is the distributor. The replication used one standard login
account "subscriber" for all of its purposes.
What happened is that our system administrator upgraded the SQL Server
without taking the replication into consideration. Considering that this
setup is still in its testing phases, we wanted to drop the existing
subscription/subscriber database, upgrade the MSDE database to SP3 too, and
then re-establish the replication. All was fine until we wanted to
synchronise: all options at the subscriber are identical as they were, the
"subsciber" account is added to the PAL list of the publication (it wasn't
there), but we get the following error when we run the agent:
"SELECT permission denied on object 'MSagent_parameters', database 'msdb',
owner 'dbo'.
(Source: Merge Process (Agent); Error number: -2147198719)"
Now, tried granting SELECT access to the "subsriber" user on the
msdb.dbo.MSagent_parameters and msdb.dbo.MSagent_profiles tables (to get
around the SELECT permissions errors), but then I get this other error:
"The process was successfully stopped.
(Source: Merge Replication Provider (Agent); Error number: -2147198719)"
Any ideas on what is going on?
Thank you in advance,
Goran
Aleem Mohammed
Go
EXEC sp_changedbowner 'sa'
Go
Ru this on Distribution database everything will be then
fine.
It was bug reported in SP3
>.
>