Sunday, March 11, 2012

Cannot create article

What are some things that would stop an article from being created? I am
running a helpfully simple Snapshot Replication on my pc. I am configuring
the SQL Server to do all three roles: Publisher, Distributor and Subscriber.
I am only replicating the Authors table from the Pubs database to a database
called Pubs_Copy.
The error messages is as follows:
SQL Server Enterprise Manager could not create article 'authors' based on
the object 'authors' Error 50007: xp_execresultset: unable to get a bound
connection back to server.
What can check?
You have a remote distributor which you do not have the correct
administrative password for.
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
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:EE5015FD-8630-409A-BC9C-EF91E0480C8A@.microsoft.com...
> What are some things that would stop an article from being created? I am
> running a helpfully simple Snapshot Replication on my pc. I am
configuring
> the SQL Server to do all three roles: Publisher, Distributor and
Subscriber.
> I am only replicating the Authors table from the Pubs database to a
database
> called Pubs_Copy.
> The error messages is as follows:
> SQL Server Enterprise Manager could not create article 'authors' based on
> the object 'authors' Error 50007: xp_execresultset: unable to get a bound
> connection back to server.
> What can check?

No comments:

Post a Comment