Sunday, February 12, 2012

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 SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:507B14EC71864@.SQLMonster.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

No comments:

Post a Comment