Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 replication between mac having diff public IP addr

Author  Topic 

Soumen Dey
Starting Member

20 Posts

Posted - 2004-09-07 : 07:39:44
Hi,

I have a system which is guarded by linux (SUSE) firewall. Now I want to replicate with a mac which is at a remote place having a public IP from the mac inside the firewall. I've opened 3 polling ports and one listening port at the firewall namely 1746,1747,1748 and 1433. Unfortunately I could not carry on with replication, Can any body suggest me what should I do. It is very urgent, You can mail me your valuable tips at soumen_dey@hotmail.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-07 : 13:35:11
What is the error that you are receiving? Can the two SQL Servers talk to each other?

Tara
Go to Top of Page

Soumen Dey
Starting Member

20 Posts

Posted - 2004-09-08 : 05:38:27
Yes I Can register the server, but when I 'm trying to configure a distributor , I get an error message error 18483 - could not connect to server because distributor_admin is not defined as a remote login at the server. Please suggest
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-09-08 : 05:44:29
you need to map the remote login you're using from the distributor/publisher to the subscriber.

also check if the account from the publisher is sysadmin on the subscriber

from experience, when you create the publication and subscriptions, the distributor admin is created automatically and mapped out.

check if this account was dropped/deleted
Go to Top of Page
   

- Advertisement -