Re: Entreprise Replication
Posted in 1998
A couple of things that you need to check:
1. Each instance of Online must have it's own TCP/ip services dedicated to
it's SQLEXECD process.
2. Ensure that the SERVERID is unique for each Online instance.
3. Ensure that your Group ID numbers are unique
4. The SQLHOSTS file on all servers must identical.
Prior to starting RepMan a test you can run to ensure that you have
connection rights is to execute a distributed database select from the one
server to a database on the remote server.
i.e. Connect to SERVER_A, and through dbaccess/SQLEditor run 'SELECT * FROM
stores7@SERVER_B:customer'. Execute this viseversa. If no error's occur
then thing should startup fine.
Try this out and let me know.
Dennis Harding
Mike Lebrun wrote in message <6frjbr$gde$1@newsbell.bellglobal.com>...
>Hello All,
>
>I'm having problems setting up Entreprise Replication:
>
>I have my snmp daemon running, and the cdragt sub-agent. Everything works
>great for one server: I can declare one server to ER, and define a
>replicate. However, when I try to connect to second server, and declare it
>to ER, using the first server as a synch server, it bombs.
>
>If I remove the first server, and then try declaring the second server, it
>works OK, but when I try to redeclare the first server to ER again, CDR
>bombs on the first server now.
>
>What a pain: has anybody experienced this? Does anybody have any ideas?
>
>Thanks!
>
>
>