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
Sunday, February 12, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment