The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it.

Question

Post reply

The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it.

n_padma

Old Hand

Points: 316
More actions
November 5, 2008 at 5:06 am

#195659

I have created Transaction-updatable replication between two databases in Sqlserver2005. When i update the table at subscriber, the following error occured.
No row was updated
The data in row1 was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it.
Updateable Subscriptions: Rolling back transaction.
The transaction ended in the trigger. The batch has been aborted.
Please provide me a solution.
Padmavathi

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 1

A wild guess:

Have a look at

http://sql-server-performance.com/Community/forums/p/28131/151182.aspx.

They mention verifying authentication setup and the linked server connection.

n_padma Old Hand Points: 316 More actions · Answer 2

The link provided is not available.

Give me solution.

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 3

Sorry, the extra dot was really tight

http://sql-server-performance.com/Community/forums/p/28131/151182.aspx

n_padma Old Hand Points: 316 More actions · Answer 4

I couldnot find the solution. please provide solution

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 5

The first link deals with the added RPC security of Windows 2003 (and MSDTC)

(starting at Set the appropriate MSDTC Security Configuration options on Windows Server 2003 SP1 and Windows XP SP2 )

http://msdn.microsoft.com/en-us/library/aa561924.aspx

Also check if there is a firewall inplace.

CrazyMan SSChampion Points: 12560 More actions · Answer 6

Hi Padma

Check your settings, connect your other server from your server where you have configured replication, this are the base steps that you can check, if you cant connect then there are some problems, if you can then please let us know

Cheers

🙂

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 7

check the SQL Server Surface Area Configuration. and enable relevant options.

n_padma Old Hand Points: 316 More actions · Answer 8

Replication : Transaction - updateable

I had established the connection of that sqlserver from my m/c. After that i updated the table at my publisher end. It got updated at the subscriber end.

But when i Updated the table at the subscriber end, it is not getting updated and shows the error.

zaizai1780 Valued Member Points: 72 More actions · Answer 9

we have transactional replication with updateable subscription setup between 2 servers. This was already working last year and suddenly had a problem with below error last Monday.

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, Procedure spSetMyVehiclesReq, Line 28

The transaction ended in the trigger. The batch has been aborted.

The linked server is present.

The sql account used on the linked server is working and can connect to the publisher/subscriber vv.