Analysis Services install on Project Server 2007 server

[David Blair]

I would like to install Analysis Services on my Project Server 2007 computer
along with the Web Server and front end components. So I would end up with
SQL server 2005 on one server and server 2 would have the rest (company
doesn't want Analysis Server on the SQL box). Any issue with this? (besides
the obvious performance risk). Is seems this may be possible by installing
SQL Server Native Client; Management Object Collections; SQL 2005 Backward
Compatible components and then going through the steps using a share folder
for the repository on the PS computer. Any thoughts on this? Thank you.
David

 

[Marc Soester [MVP]]

HI David,

I would install Analysis Services on the DB Server or seperate server to be
honest. Generally I would not recommend putting analysis services on the app
server. i believe that has license implications ( but you will have to check
with MS) and will more then likely have preformance implications.
Hope this helps

 

[Ben Howard]

You'll need another SQL Server licence for this configuration. I'm not sure
you get a big perf hit, exept maybe during cube build time, but as this
happens out of hours it shouldn't hit you.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/