What Access do publisher servers need with push subscripti..

When setting up security access between a publisher and subscriber, what
needs to be done?

I can't find a checklist of things to do when setting up connection and
access details from a publisher to a subscriber - is there something online
anywhere?

Do I just need a LAN or VPN connection to the publisher server?

I have a number of push subscriptions (at least one snapshot and one merge)
to send to the subscriber.

I won't obviously be using web synchronisation because we have a snapshot
subscription.

I am using SQL Server 2005 on both servers, but next month I have to set
something up with SQL Server 2000, so if there is something available for
both I would like to see it.

Thanks!

That's a complex question, however if its push, the subscriber login account
must be in the dbo role in the subscription database.

If its pull, the publisher login must have rights to list files and folders
on the snapshot share, and have read permission on the share. The login must
be in the dbo_role in the distribution database, and in the dbo_role on the
publication database or in the PAL of the publication.

--
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
"Jane Parker" wrote in message

> When setting up security access between a publisher and subscriber, what
> needs to be done?
>
> I can't find a checklist of things to do when setting up connection and
> access details from a publisher to a subscriber - is there something
> online anywhere?
>
> Do I just need a LAN or VPN connection to the publisher server?
>
> I have a number of push subscriptions (at least one snapshot and one
> merge) to send to the subscriber.
>
> I won't obviously be using web synchronisation because we have a snapshot
> subscription.
>
> I am using SQL Server 2005 on both servers, but next month I have to set
> something up with SQL Server 2000, so if there is something available for
> both I would like to see it.
>
> Thanks!
>
>