Remote Replication

[mohsinnazir]

Hello Guys,
I am trying to do remote transactional replication But it is giving me following error.

Publisher is on server A
Subscriber in on server B

The process could not connect to Subscriber B

Any suggection Appriciated

 

[ptheriault]

You when you set up replication you must specify a login account for replication to use.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mohsinnazir]

Thanks paul,
I have set up the login for subscriber and publisher.
Publisher using sql server agent default username and password and subscriber using database username and password subscriber user has db_owner rights