OLAP Problem

[Stephane M]

Hi have a project server 2003, IT's on a Windows 2003 R2 Sp2 Server,
My SQL it's on another serveur, My SQL Server it`s a SQL 2005 SP2.

If i want create the cude i receved this (2) error:

------------------------------------------------------------------------------------------------
Source: Microsoft Project Server
ID évén: 2

Component: MSP Resource Availablity Refresh and OLAP Cube Component (ProjOlap)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[DSO.Server.Connect.failed with error
message
`ActiveX component can`t create object`Error Number: `429]]></Description>

------------------------------------------------------------------------------------------------
Source: Microsoft Project Server
ID évén: 2

Component: MSP Resource Availablity Refresh and OLAP Cube Component (ProjOlap)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>
------------------------------------------------------------------------------------------------

 

[NZ Projects]

Have you installed the following on your Proj Server ?

1. Microsoft SQL Server Native Client (sqlncli.msi)
2. Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi)
3. Microsoft SQL Server 2005 Backward Compatibility Components
(SQLServer2005_BC.msi)

These components can be downloaded from the Feature Pack for Microsoft SQL
Server 2005 - April 2006 release, available on:
http://www.microsoft.com/downloads/...aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

 

[Stephane M]

Hello,

Yes all of his feature is installed on my ProjectServer 2003 !

And I read many post on Internet, and I don't sea the anser !

Have you installed the following on your Proj Server ?

1. Microsoft SQL Server Native Client (sqlncli.msi)
2. Microsoft SQL Server 2005 Management Objects Collection
(sqlserver2005_xmo.msi)
3. Microsoft SQL Server 2005 Backward Compatibility Components
(SQLServer2005_BC.msi)

These components can be downloaded from the Feature Pack for Microsoft SQL
Server 2005 - April 2006 release, available on:
http://www.microsoft.com/downloads/...aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

Hi have a project server 2003, IT's on a Windows 2003 R2 Sp2 Server,
My SQL it's on another serveur, My SQL Server it`s a SQL 2005 SP2.

If i want create the cude i receved this (2) error:

------------------------------------------------------------------------------------------------
Source: Microsoft Project Server
ID évén: 2

Component: MSP Resource Availablity Refresh and OLAP Cube Component (ProjOlap)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[DSO.Server.Connect.failed with error
message
`ActiveX component can`t create object`Error Number: `429]]></Description>

------------------------------------------------------------------------------------------------
Source: Microsoft Project Server
ID évén: 2

Component: MSP Resource Availablity Refresh and OLAP Cube Component (ProjOlap)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[Error #: 0 Desc. :]]></Description>