Re: Replication to DMZ...something's missing....HELP!!!!!



I don't believe this will work. MSDTC needs RPC ports open for inbound
traffic on both sides of your DMZ.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"JLS" <jlshoop@xxxxxxxxxxx> wrote in message
news:ue1ctaF7FHA.3880@xxxxxxxxxxxxxxxxxxxxxxx
I've followed the steps in an attempt to replicate to & from the DMZ sql
server.
It's a one-way trust.
Replication, Trans. Repl w/ Immediate Update is setup
My domain sql server can replicate to the dmz, but when I try to change
something at the subscriber it tells me
"SQL Server not found or access denied"

I have attempted everything from the article on Replication Answers.
Server is in hosts file
I setup an alias in Client Network utilities using the IP Address that I
input in the hosts file

What else can I do to replicate back from the DMZ? What am I missing?





.



Relevant Pages

  • Re: Questions about RDA & Replication
    ... When performing RDA relations are not preserved in the corresponding sql ce ... when performing replication relation for a table T are preserved ... > in the table on the SQL Server side. ... One approach is to allocate a distinct range for each subscriber and a range ...
    (microsoft.public.sqlserver.ce)
  • Re: Merge replication in SQL Server
    ... However, port 443 is for https, did you want your SQL ... Configuring an instance of SQL Server to use a static port ... you can script out replication jobs by right clicking on a publication ...
    (microsoft.public.sqlserver.replication)
  • Re: Critical services to unblock?
    ... The application is basically a ERP solution that will be run on SQL ... Would you 100% recommend me to put my 2 DMZ machines in the internal network? ... How does the App relate to the SQL Server? ... Microsoft Internet Security & Acceleration Server: ...
    (microsoft.public.isa.configuration)
  • Re: QUEUE READER - A FREQUENT PROBLEM!
    ... Looking for a SQL Server replication book? ... queue table and the same transaction coldn't be inserted at the ...
    (microsoft.public.sqlserver.replication)
  • Re: Merger Replication - SQL 2000/2005
    ... Microsoft SQL Server Management Studio is unable to access replication ... components because replication is not installed on this instance of SQL ... Installing Replication in SQL Server Books Online. ...
    (microsoft.public.sqlserver.replication)

Loading