We are facing a lot of problem with replication between SQL Server 2008 R2 servers. Let me describe the scenario..
We have 20 branches and one main Server in our organization, all are running SQL Server 2008 R2. The Main server is a Windows 2008 R2 x64 bit computer from which we want to create both way transaction replication (Data inserted in to any branch will be reflected
to the main server and from there all other branches will get the same data) to all other branches. Branch machines are 32 bit XP sp3 or Windows 7. All the machines are under workgroup. Among 20 branches we could successfully establish both way replication
on 5 branches only. When we are trying to publish data from main server to say Branch A (with windows 7), it says "The process could not connect to Subscriber 'A'". We can ping to branch A and can login to Branch A from Main server
through Management Studio which proves that there is no connectivity issue. Branch A can publish data to Main server without any problem. Even Branch A can subscribe data from another branch Branch B.
I cannot understand why this problem is happening for other 15 branches to subscribe data from Main Server. I have some queries in mind
- Is there any upper limit of subscription no?
- Is there any problem with windows 7?
Any help in
View Complete Post