Hello,
we are using windows 2003 servers on the branches and we have good links 1Mbit/s. I have configured Transactional replication in order branches to replicate in HQ. It is happening very often that we are not able to access these servers with Remote Desktop and SQL Server Enterprise Manager, only some small queries through query analyzer. And if I go and check the replication the error is appearing "General Network Error - check your network documentation ..", can anybody explain me why this is happening very often? Managment is saying maybe bacause of replication - communication with servers is failing!! in the other hand we can ping these servers. (and finally the only solution is restarting them?!!?)
Thanks a lot,
ProBani.
we are using windows 2003 servers on the branches and we have good links 1Mbit/s. I have configured Transactional replication in order branches to replicate in HQ. It is happening very often that we are not able to access these servers with Remote Desktop and SQL Server Enterprise Manager, only some small queries through query analyzer. And if I go and check the replication the error is appearing "General Network Error - check your network documentation ..", can anybody explain me why this is happening very often? Managment is saying maybe bacause of replication - communication with servers is failing!! in the other hand we can ping these servers. (and finally the only solution is restarting them?!!?)
Thanks a lot,
ProBani.