Re: enterprise replication
Posted in 2001
Topics: High Availability & Replication, Networking & sqlhosts Configuration
Yes, Both servers are trusting each other. Stil I am unable to connect Brett Randall wrote: > Praveen Tummala wrote: > > > > Hi all, > > > > I am trying to set up enterprise replication between two servers. > > Sqlhosts files of both the servers contain same information. Both > > servers are using tlitcp connections. I started one server as a > > replication server. But when I try to start the second server as a > > replication server from the first one using --connect option, an error > > is returning :- unable to connect the server specified; For information, > > first server is in Belgium, and second one is in India. I could not > > understand what the problem is. Can anyone help me plase? > > > > Thanks, > > Praveen. > > Have you checked the "trust" between the two servers? This is a common > problem with replication setup. If your servers are Unix, review your > "hosts.equiv" or ".rhosts" settings. > > Brett Randall
Praveen Tummala wrote: > > Hi all, > > I am trying to set up enterprise replication between two servers. > Sqlhosts files of both the servers contain same information. Both > servers are using tlitcp connections. I started one server as a > replication server. But when I try to start the second server as a > replication server from the first one using --connect option, an error > is returning :- unable to connect the server specified; For information, > first server is in Belgium, and second one is in India. I could not > understand what the problem is. Can anyone help me plase? > > Thanks, > Praveen. Have you checked the "trust" between the two servers? This is a common problem with replication setup. If your servers are Unix, review your "hosts.equiv" or ".rhosts" settings. Brett Randall
You probably have a misconfiguration in one of your sqlhosts files. I'd examine them first. If you can't figure out where the inconsistancy, then I suspect that you can get this fixed quickest by contacting tech support.