Could not Create Publication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bharathi - 26 Dec 2006 14:26 GMT

Hi,
I created 2 windows user named PublishUser and ReplSnapAgent with less
previllege. Ran SSMS using PublishUser and created snapshot publication.
Used RepSnapAgent user as Snapshot Agent. I got an error saying

SQL Server could not create publication 'Product'. (New Publication Wizard)
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Proxy "Computer-Name\ReplSnapAgent" is not a valid Windows user.
Changed database context to 'ReplTesting'. (.Net SqlClient Data Provider)

Is anybody else help me out in solving this issue?

Reply to this Message

Hilary Cotter - 27 Dec 2006 16:47 GMT

Is ReplSnapAgent a local user account on the computer Computer-Name? Is it
in the dbo_role on the distribution database and the publication?

Signature

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

> Hi,
> I created 2 windows user named PublishUser and ReplSnapAgent with less
[quoted text clipped - 9 lines]
>
> Is anybody else help me out in solving this issue?

Reply to this Message