G
Guest
Hello Everyone,
I have installed Project Server 2007 on two systems. Bobs2005db is a SQL 2005
Server. BobsSmallps is the web SharePoint and project server. Everything
appears to be working but I am having some difficulty getting the OLAP cube to
build.
After getting the DSO components required messages I installed the SQL
compatibility kit. Now I am seeing the following errors:
===== Initiating cube build process =====
[3/26/2007 4:03 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[3/26/2007 4:04 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[3/26/2007 4:04 PM] Cube build initialization started
[3/26/2007 4:04 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[3/26/2007 4:04 PM] Cube build session started
[3/26/2007 4:04 PM] Analysis Services session started
[3/26/2007 4:04 PM] Analysis Services session failed with the following error:
Failed to connect to the Analysis Services server Bobs2005db. Error: ActiveX
component can't create object
===== Process Completed =====
[3/26/2007 4:04 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server Bobs2005db. Error: ActiveX component can't create object
What ActiveX component is trying to create what object?
Does the management account used for SharePoint and Project Server need
privileges on the SQL server?
Bob
I have installed Project Server 2007 on two systems. Bobs2005db is a SQL 2005
Server. BobsSmallps is the web SharePoint and project server. Everything
appears to be working but I am having some difficulty getting the OLAP cube to
build.
After getting the DSO components required messages I installed the SQL
compatibility kit. Now I am seeing the following errors:
===== Initiating cube build process =====
[3/26/2007 4:03 PM] Cube build request message has been added to the Project
Server queue
===== Verifying and running pre-build server event handler =====
[3/26/2007 4:04 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[3/26/2007 4:04 PM] Cube build initialization started
[3/26/2007 4:04 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[3/26/2007 4:04 PM] Cube build session started
[3/26/2007 4:04 PM] Analysis Services session started
[3/26/2007 4:04 PM] Analysis Services session failed with the following error:
Failed to connect to the Analysis Services server Bobs2005db. Error: ActiveX
component can't create object
===== Process Completed =====
[3/26/2007 4:04 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to connect to the Analysis
Services server Bobs2005db. Error: ActiveX component can't create object
What ActiveX component is trying to create what object?
Does the management account used for SharePoint and Project Server need
privileges on the SQL server?
Bob