here what I want to do,
1) transactional replication using two servers
2)Configure one server as publisher and distributor
3)Create publication on server 1
4)Create immediate update push subscription on server 2
5)I want bidirectional replication
First three steps I have created successfully
for step 4,
I created a push subcription from server 1 on publication created in step 3.
I am unable to find the option "immediate updating subscriber" in the wizard of creating push subcription.
anyway even without this option I am unable to create the replication.
in the replication monitor it is displaying as follows for the publication,
Snapshot--------succeeded---------snapshot of 1 artile created
Log reader------idle-----------------no replicated transaction available
Server2:db2----Push----failed-----the process could not connect to subscriber 'Server2'
I succeeded creating replication from Server1 to server2.
The problem is Server1 is in one domain and Server2 is in seperate domain.
the data is being replicated from S1 to S2
the problem is when I add/update any record in S2 database then it gives error that,
"Login failed for user sa"
what should i do next
which user account should I set up at subscriber i.e S2
Q: One last recommandation, write script if you can.
what do you mean by that, as I am using Enterprise manager
In BOL, under system stored procedure there is a section with all the system stored procedures you need to create or disable replication. Writing script gives you more control in the replication setup. You can start out using EM, but eventually you will find things that you can't do with EM.