Project server using MOSS and a seperate SQL Server

[Charles]

I've been testing using Project Server installed on a full MOSS server - it
works pretty well - with one exception - the Data Analysis. I have a
seperate SQL 2005 Server for the MOSS server (where Project Server is
installed_ - however the cube will not build, even thought DSO components
are installed on both the app and the SQL server). I'm thinking the problem
is becuase Project Server is trying to use the DSO components on the app
server and not on the seperate SQL server, where Analysis Services is and
all the configs are. Anyone had any experience with this? The cube build
keeps generating the Analysis Services session failed with the following
error: The Application Server needs to have Analysis Services DSO Component
installed error.

 

[Christophe Fiessinger [MSFT]]

Charles it should work, have you reviewed the documentation from TechNet on
this subject:
http://technet.microsoft.com/en-us/library/cc303402.aspx