Merge replication Error (-2147467259) -- sql server replication

Wellington Sampaio
6/14/2006 6:37:01 AM

Hello!

I got the following error in my merge replication.

Category:NULL
Source: Merge Process
Number: -2147467259
Message: The Stored Procedure Resolver encountered the following error
executing the stored procedure '[dbo].[stp_Repl_dml_estoque]'. Server
'SERVIDOR' is not configured for DATA ACCESS.

The stored procedure '[dbo].[stp_Repl_dml_estoque]' act as an articlesÂ´s
conflict resolver.
When i run the replication this error is showed, and the process is stoped.

Thanks!

Jeff Ericson
6/14/2006 6:45:03 AM

Does the sproc reference a linked server? If so, the linked server is not
set for data access. Right click on linked server, last item in tree you
will find data access set to false. Flip it to true.

Jeff

[quoted text, click to view]

Wellington Sampaio
6/14/2006 7:00:02 AM

Yes, youÂ´re right!

But my replication run at the same machine. The Distributor, publisher and
the subscriber are at the same machine. And, you guess, i canÂ´t create a

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Merge replication Error (-2147467259)