"Darrell" <Darrell.Wright.nospam@okc.gov> wrote in message
news:e1LlIionFHA.3256@TK2MSFTNGP12.phx.gbl...
> Hey folks!
>
> I am trying to set up a snapshot replication. The publisher and
> distributer are the same machine. Every time the snapshot agent runs I get
> the following error message:
>
> The publisher login of the snapshot agent must be a member of the sysadmin
> role or db_owner role.
> SELECT permission denied on object 'syspublications', database 'fire',
> owner 'dbo' (Source blah blah blah...)
>
> When I look at the agent properties and check the owner, I make sure that
> login is in the System Administrators role on the server and that it is in
> the db_owner role in the database (to cover all the bases).
>
> Why won't my agent run?
>
> Thanks for your help.
>
> Darrell

ChrisR wrote:
> RClick the server in EM/ Props/ Replication/ Configure/ Publishers and
> Subscribers/ Elipses(...)/ Agent connection to the (Pub, Sub) , make sure
> all that info is correct.
>
>
>
>
> "Darrell" <Darrell.Wright.nospam@okc.gov> wrote in message
> news:e1LlIionFHA.3256@TK2MSFTNGP12.phx.gbl...
>
>>Hey folks!
>>
>>I am trying to set up a snapshot replication. The publisher and
>>distributer are the same machine. Every time the snapshot agent runs I get
>>the following error message:
>>
>>The publisher login of the snapshot agent must be a member of the sysadmin
>>role or db_owner role.
>>SELECT permission denied on object 'syspublications', database 'fire',
>>owner 'dbo' (Source blah blah blah...)
>>
>>When I look at the agent properties and check the owner, I make sure that
>>login is in the System Administrators role on the server and that it is in
>>the db_owner role in the database (to cover all the bases).
>>
>>Why won't my agent run?
>>
>>Thanks for your help.
>>
>>Darrell
>
>