Hi,
I am new to this replication thing and got bogged down on this issue.
My system consists of:
1. Publisher, SQL 2000 login xxxx password yyyy. Transactional
replication. Allow pull. On PAL, xxxx exists. Snapshot on default
folder
2. Subscriber, SQL 2005, existing on non-trusted domain, login xxxx
password yyyy. Pull replication. Read snapshot from default. Agent
process account = Subscriber\xxxx, Distributor connection = xxxx using
sql server authentication (I tried Impersonating but won't work).
Publisher can create a snapshot but Subscriber seem to have problem. I
cannot possibly add Subscriber\xxxx into PAL because it's not a
trusted domain(?). What am I doing wrong? Please help.
ben
error 5 is generic access denied. Is the snapshot folder shared? And does
the SQL Server Agent account or the account you are impersonating with have
read and list files and folders rights on the snapshot share and underlying
files and folders?
http://www.zetainteractive.com - Shift Happens!
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
"benito" <lochinvar.geo@.gmail.com> wrote in message
news:f7d8b5fe-38d1-4073-b4d4-6f2d5023e272@.o6g2000hsd.googlegroups.com...
> Hi,
> I am new to this replication thing and got bogged down on this issue.
> My system consists of:
> 1. Publisher, SQL 2000 login xxxx password yyyy. Transactional
> replication. Allow pull. On PAL, xxxx exists. Snapshot on default
> folder
> 2. Subscriber, SQL 2005, existing on non-trusted domain, login xxxx
> password yyyy. Pull replication. Read snapshot from default. Agent
> process account = Subscriber\xxxx, Distributor connection = xxxx using
> sql server authentication (I tried Impersonating but won't work).
> Publisher can create a snapshot but Subscriber seem to have problem. I
> cannot possibly add Subscriber\xxxx into PAL because it's not a
> trusted domain(?). What am I doing wrong? Please help.
> ben
|||Thanks for your reply Hilary. I reviewed the folder rights, password,
logins to make sure they are correct and now it seems to work fine.
ben
On Dec 4, 9:23 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> error 5 is generic access denied. Is the snapshot folder shared? And does
> the SQL Server Agent account or the account you are impersonating with have
> read and list files and folders rights on the snapshot share and underlying
> files and folders?
> --http://www.zetainteractive.com- Shift Happens!
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"benito" <lochinvar...@.gmail.com> wrote in message
> news:f7d8b5fe-38d1-4073-b4d4-6f2d5023e272@.o6g2000hsd.googlegroups.com...
>
>
>
>
> - Show quoted text -
No comments:
Post a Comment