Good afternoon Hilary,
Your suggestion and quick response were greatly appreciated but I did not
adequately describe the scenario. We are attempting to establish a one-way
transactional push replication from inside our firewalled domain to a SQL
Server in your DMZ. We will be horizontally and vertically filtering the
replicated data. Please excuse my lack of networking saavy as this is my
first attempt at replication. I believe you mentioned in your book that you
could not have an anonymous push subscription. I am only prtially finishe
dwith your book and it has been quite a help thus far but I am facing a
deadline for getting this to work or to use one of the other methods you
mentioned in Chapter 1. Thanks for your help
[quoted text, click to view] "Hilary Cotter" wrote:
> Make it an anonymous subscriber and it should work. I don't think I recall
> talking about this in the book.
>
> --
> 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 >
> "Dave Stokes" <DaveStokes@discussions.microsoft.com> wrote in message
> news:129DBEBA-EF02-4B1E-B858-F33D48E66E8A@microsoft.com...
> > Hello,
> > I am attempting to setup a transactional scheme from an instance of SQL
> > server 2K inside our firewall to an instance running in our DMZ. I am
> > getting the error "SQL Server does not exist or access denied.
> > (Source: <DMZ server name> (Data source); Error number: 17)"
> > I have been reading books online and haven't found anything on this
> > particular topic. BTW, I just ordered Hilary Cotter's book on
> > Transactional
> > and Snapshot replication but was hoping someone may be able to point me in
> > the right direction before it gets here. TIA
>
>