push replication failing - firewall
From: Cate Donoghue (Donoghue_at_discussions.microsoft.com)
Date: 09/03/04
- Next message: faustino Dina: "Publishing initial snapshot through IIS like SSCE..."
- Previous message: Yehuda: "modifying sp_repladdcolumn?"
- Next in thread: Paul Ibison: "Re: push replication failing - firewall"
- Reply: Paul Ibison: "Re: push replication failing - firewall"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Sep 2004 06:25:04 -0700
I have the following set up:
server1 - wink2k server - inside the firewall, live database, created a
local admin user and made the SQL Server agent run with it. Made the user an
sa and gave it database owner on the replication database.
server2 - win2k3 server - in the dmz. Want this to maintain a copy of the
live database, but no updates. created a local admin user, named it the same
as on server1, gave same permissions everywhere, same password. Only stateful
connections are allowed to pass back into the internal network.
I am able to register server2's sql server in EM, although I had to up the
timeout to 90 seconds. I can import a database using EM from server1 to
server2. Server2 has a hosts file with the ip address of server1, but ping is
disallowed.
I am attempting a simple push replication. The schema and data are on
server2 (I simply imported it using EM rather than FTPing) The replication
starts and shows "Connecting to subscriber 'server2'" and at exactly the
timeout (even if I set it to 10 minutes) I get a failure of "The process
could not connect to Subscriber 'server2'" and the error is "SQL Server does
not exist or access denied.", not a timeout error.
I went into the distribution database on the distributor, and changed the
push to a no sync, didn't make any difference.
Settings on the subscriber tab have been set to impersonation, but also have
tried using a sql auth login.
Pretty much everything I've seen with people having problems with a push
also had problems getting the server registered in EM. I'm at a loss and I
have to get this working. Any ideas?
- Next message: faustino Dina: "Publishing initial snapshot through IIS like SSCE..."
- Previous message: Yehuda: "modifying sp_repladdcolumn?"
- Next in thread: Paul Ibison: "Re: push replication failing - firewall"
- Reply: Paul Ibison: "Re: push replication failing - firewall"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
