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?

Cannot connect to analysis services 'servername'

Hi,
I am very new to using Analysis services, so please bare with me. I am
running dqlserver service pack 4 which has AS sp3 bundled within. Everything
is on the same box.
I am trying to schedule a job from my sql server to build me cubes.
The local package works but when I schedule, I receive an error.
Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
Executing... Error string: Cannot connect to the Analysis server on
computer 'BDA-REPORTING01'. Connection to the server is lost
I have tried to add myself to OLAP admin group, edited the repository string
,
added to local admin.
Please help DebraCheck if the account under which SQLServerAgent runs (RENRE\RenreSQLAgent ?)
is a member of OLAP Administrators group of the computer 'BDA-REPORTING01'
Francesco Anti
"Debra Ramlal via droptable.com" <forum@.droptable.com> wrote in message
news:507B14EC71864@.droptable.com...
> Hi,
> I am very new to using Analysis services, so please bare with me. I am
> running dqlserver service pack 4 which has AS sp3 bundled within.
> Everything
> is on the same box.
> I am trying to schedule a job from my sql server to build me cubes.
> The local package works but when I schedule, I receive an error.
> Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
> Executing... Error string: Cannot connect to the Analysis server on
> computer 'BDA-REPORTING01'. Connection to the server is lost
> I have tried to add myself to OLAP admin group, edited the repository
> string,
> added to local admin.
> Please help Debra

Cannot connect to analysis services 'servername'

Hi,
I am very new to using Analysis services, so please bare with me. I am
running dqlserver service pack 4 which has AS sp3 bundled within. Everything
is on the same box.
I am trying to schedule a job from my sql server to build me cubes.
The local package works but when I schedule, I receive an error.
Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
Executing... Error string: Cannot connect to the Analysis server on
computer 'BDA-REPORTING01'. Connection to the server is lost
I have tried to add myself to OLAP admin group, edited the repository string,
added to local admin.
Please help Debra
Check if the account under which SQLServerAgent runs (RENRE\RenreSQLAgent ?)
is a member of OLAP Administrators group of the computer 'BDA-REPORTING01'
Francesco Anti
"Debra Ramlal via droptable.com" <forum@.droptable.com> wrote in message
news:507B14EC71864@.droptable.com...
> Hi,
> I am very new to using Analysis services, so please bare with me. I am
> running dqlserver service pack 4 which has AS sp3 bundled within.
> Everything
> is on the same box.
> I am trying to schedule a job from my sql server to build me cubes.
> The local package works but when I schedule, I receive an error.
> Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
> Executing... Error string: Cannot connect to the Analysis server on
> computer 'BDA-REPORTING01'. Connection to the server is lost
> I have tried to add myself to OLAP admin group, edited the repository
> string,
> added to local admin.
> Please help Debra