Hi
We're having problems with push replication to multihomed clients. if the DNS contains multiple IP's and one of those are not reachable from the sql server. the replication fails. no matter order of IP adresses. i wrote a DNS proxy which re-ordered the IP's so that the "working" IP would come first in the list but no success until i filtered out so that the DNS proxy only replied with one, the working, IP.
the replication is part of a commercial application which we have no control over. are there any settings on the server side that can help here? I really want to fix the source of the problem and not patch it with a proxy.
any ideas are welcome. the server is sql 2005 standard and the clients are running 2005 express
Rgds
just an update, if anyone has the same problem
i found out how it works by reading this thread.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1526698&SiteID=1
this doesnt fix the problem. but it explains it very well. so we'll stick with the proxy.
No comments:
Post a Comment