Project Server 2007 Cube Failure

[Jay]

HI There

I have setup a project sever enviroment. Now I receive the following error :

Analysis Services session failed with the following error: Failed to connect
to the Analysis Services server LOCALSQL. Error: ActiveX component can't
create object.

Now I have trouble shooting everything as per Microsoft.

1. Updated the DSO Componants.
2. Registered the Olap users on SQL and PS2007

My Setup is a 3 tier enviroment.

1. MOSS2007
2.Project SERVER 2007
3. SQL 2005 SP1 & SP2

Any help.

Regards
Jay

 

[Mark Everett | PMP]

HI There

I have setup a project sever enviroment. Now I receive the following error :

Analysis Services session failed with the following error: Failed to connect
to the Analysis Services server LOCALSQL. Error: ActiveX component can't
create object.

Now I have trouble shooting everything as per Microsoft.

1. Updated the DSO Componants.
2. Registered the Olap users on SQL and PS2007

My Setup is a 3 tier enviroment.

1. MOSS2007
2.Project SERVER 2007
3. SQL 2005 SP1 & SP2

Any help.

Regards
Jay

Jay,

Try this:

Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi)


It can be obtained here:


http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4b...
D isplayLang=en

Mark Everett
www.catapultsystems.com

 

[Jay]

Jay,

Try this:

Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi)


It can be obtained here:


http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4b...
D isplayLang=en

Mark Everett
www.catapultsystems.com


Hi There

Thank you for the advise.

However the Management Objects to form part of the additional companants
such as :

SQL Native Client
Management Objects
Backward Compatibility

I have intsalled all of them. However the same error.

Any advise

Regards
Jozua

 

[Gary L. Chefetz [MVP]]

Jay:

Did you add the SSP service account to the Analysis Services Server Role?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com