Re: Browsing for Publication error message

can you try a nosync?

--
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:ebk7Zx49FHA.1996@xxxxxxxxxxxxxxxxxxxxxxx
I tried yet another approach....

I pulled the initial snapshot folder off the publisher & put it on the
subscriber. In the subscription properties, I told it to look in this
folder on the subscriber, but I get an error message that the process could
not read the file.

I'm just trying everything & I think I'm down to my problem has to do with
the initial snapshot. PLEASE shove me in the right direction.....


"JLS" <jlshoop@xxxxxxxxxxx> wrote in message
news:OvacGx39FHA.2616@xxxxxxxxxxxxxxxxxxxxxxx
I have setup everything from my domain to the dmz following the document
from Replication Answers.com "Replication Across Non-Trusted Domains or
Using the Internet"

When setting up the anonymous pull subscription, browsing for the DMZ
publication, I see the DMZ server (Publisher) but when I click the (+) to
view publications I am receiving the error message;
"Could not obtain information about Windows NT group / user 'DOMAIN
NAME/SQLAdministrator' "
This is the account that runs my Sql Server Agent of the sql server in the
domain (The Subscriber)

I don't want to use this account, the DMZ server is a part of the
domain!!!! I have setup a sql account on both the domain sql server & the
dmz sql server.

What am I missing? Where would it be retrieving this account?

I feel like I am so close. I was actually able to create a subscription
by using Hilary's book & scripts from QA (But couldn't get the Agent to
start - Start/Stop Agent were grayed out)

--
JLS


.

Relevant Pages

  • Re: Server to server Replication
    ... Replicated data is mostly read-only at the Subscriber. ... You need updates to be propagated on a transaction basis, ... Use snapshot replication or transactional replication with immediate ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem with merge replication
    ... subscriber changes before the new snapshot comes down. ... Looking for a SQL Server replication book? ... I use merge replication with windows CE clients and SQL Server 2005. ... If someone collects data in an existing table on the client (the ...
    (microsoft.public.sqlserver.replication)
  • NOT FOR REPLICATION clause in triggers that are replicated to subscribers are fired twice in both pu
    ... transactional replication trought VPN with updatable subscriptions to SQL ... of then marked as NOT FOR REPLICATION and copied along to the subscriber) so ... This is true for SQL Server 2000 either the insertion/update/deletion ... happens on the publisher or the subscriber: Ie, if the user is connected to ...
    (microsoft.public.sqlserver.replication)
  • Re: merge Replication with a Notebook not in domain
    ... subscriber ... Looking for a SQL Server replication book? ... The Notebook is non link to the Domain but it use a Workgroup Access to ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication to DMZ...somethings missing....HELP!!!!!
    ... Looking for a SQL Server replication book? ... I've followed the steps in an attempt to replicate to & from the DMZ sql ...
    (microsoft.public.sqlserver.replication)