Data analysis Error.

[Siskin]

Hi,

Am having a problem in building cubes after all the DSO configuration, getting the following error message.

Application server (Project Server 2007) and SQL server 2008 are on two different machines.

getting the following error when building cubes after configuring the DSO.

===== Initiating cube build process =====
[1/12/2010 4:14 PM] Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
[1/12/2010 4:15 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[1/12/2010 4:15 PM] Cube build initialization started
[1/12/2010 4:15 PM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[1/12/2010 4:15 PM] Cube build session started
[1/12/2010 4:15 PM] Analysis Services session started
[1/12/2010 4:15 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server TESTSQL. Error: Cannot connect to the repository.

Analysis server: TESTSQL

Error:
Provider cannot be found. It may not be properly installed.
===== Process Completed =====
[1/12/2010 4:15 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server TESTSQL. Error: Cannot connect to the repository.

Analysis server: TESTSQL

Error:
Provider cannot be found. It may not be properly installed.


Any idea what i am missing here!