Hello,

I need help with setting up linked server for my subscriber, to connect to the publisher while seting up Transaction replication with updateable model.

When i try to create new subscription, it asks me for a linked server to be configured for establishing connection with the publisher.
now my Publisher sql server and Agent run with service account A
My subscriber sql server and Agent run with service account B
On m publisher Account B is a part of the sysadmin fixed server role and is the administrator of the box
On m Subscriber Account a is a part of the sysadmin fixed server role and is the administrator of the box

Now if i give the account details in the linked server page while setting up the subsription it gives a warning.

When i create a linked server and then give that linked server as a reference it again gives a wraning

In either case it says linked server cannot be setup and i need to use the sp_link_publication system stored procedure to create the linked server.

When i run that system stored procedure, I give the authentication mode as 2(WHich says that it will impersonate the current windows security context for creating the linked server)

when i execute the SP it says that unrecognized user Servername\Anonymous.

When i tried to search for a workaround for this issue, i see forums that say that the services if running with a doamin/account name than spn for the account needs to be registered

else run with the network service account.

However if i run with the Network service account how do i give the permission o the network service account on either machines
to the snapshot folder which has the initial snapshot.

Kindly advice or point me to some related links/forums

Thanks,
Mani