Yukon - Problem when inserting in subscriber -- sql server replication

Ki
6/13/2005 3:08:02 AM

Hi,

I created a publisher for "transaction with updateable subscription". I
created a subscriber for the publisher. (both the subscriber and publisher
are running in the same machine. i'm using hierarchical topology) Now, when I
update the subscriber, i get the following error.

Msg 21079, Level 16, State 1, Procedure sp_getpublisherlink, Line 52
The RPC security information for the Publisher is missing or invalid. Use
sp_link_publication to specify it.
Msg 20512, Level 16, State 1, Procedure sp_MSreplraiserror, Line 8
Updateable Subscriptions: Rolling back transaction.
Msg 3609, Level 16, State 1, Line 1
Transaction ended in trigger. Batch has been aborted.

i'm using SQL Server 2005 Beta 2 on win 2003 server.

Please explain what i shd do to successfully insert a record in the

Ki
6/13/2005 4:14:02 AM

Hi Paul,

I think i'm having dec CTP. I'm not sure though. But if it works in your
version, then i guess it should be working in mine as well. so please give
your suggestion if possible. Thanks

[quoted text, click to view]

Paul Ibison
6/13/2005 11:26:17 AM

Ki,
you're probably better off posting in the beta2 newsgroups if you haven't
already. I'll take a look myself if you're using April's CTP, which is the
only ine I currently have installed - please confirm.
Rgds,
Paul Ibison

Paul Ibison
6/13/2005 2:48:09 PM

Ki,
it runs fine for me. It might be a version issue but let's assume it isn't.
Please can you run this on the subscriber:
select * from MSsubscription_properties
and tell me what your 'publisher_security_mode' is.
Rgds,
Paul Ibison, SQL Server

[quoted text, click to view]

Ki
6/13/2005 9:59:01 PM

Hi Paul,

MSsubscription_properties table is empty. it does not have any rows...

[quoted text, click to view]

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 : Yukon - Problem when inserting in subscriber