BUILTIN\Administrators, sa and distributor_admin ids. And my publisher
and subscriber are running in their own local administrator accounts.
Hilary Cotter wrote:
> For push have the sql server agent run under the local administrators
> account which is in the sys_admin role.
>
> For pull, the sql server agent's on the subscriber must have rights to read
> the default snapshot share on the publisher, and the SQL server account you
> are using to pull the subscription must be in the PAL on the publication
> database and be in the dbo_role on the distribution database.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> 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 >
>
>
> "Lavanya" <lavanyah@gmail.com> wrote in message
> news:1150198911.963647.122230@u72g2000cwu.googlegroups.com...
> > Is the following solution ok?
> > 1. Have a local administrator account created on both publisher and
> > subscriber machines
> > 2. Create an SQL login account for the created account with sysadmin
> > role.
> > 3. Have my SQL servers and agents run on that account.
> >
> > Is this the only solution or any other simpler?
> >
> > Thanks,
> > Lavanya
> >
> > Hilary Cotter wrote:
> >> Its critical for pull replication.
> >>
> >> --
> >> Hilary Cotter
> >> Director of Text Mining and Database Strategy
> >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> >>
> >> This posting is my own and doesn't necessarily represent RelevantNoise's
> >> positions, strategies or opinions.
> >>
> >> 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 > >>
> >>
> >>
> >> "Lavanya" <lavanyah@gmail.com> wrote in message
> >> news:1150190434.090710.271550@c74g2000cwc.googlegroups.com...
> >> > Hi,
> >> >
> >> > When is it necessary for these 2 services to have 'this account' logon
> >> > credentials?
> >> >
> >> > I have a simple Transactional setup with local distributor and pull
> >> > subscription. Some articles say that these services should not be run
> >> > in local system account for replication. However, its working for me
> >> > otherwise.
> >> >
> >> > Help needed!
> >> >
> >> > Thanks,
> >> > Lavanya
> >> >
> >
