Showing posts with label helpfully. Show all posts
Showing posts with label helpfully. Show all posts

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?