Project Server 2003 database move and Analysis Services Repository

S

Sandy Wood

I've moved my Project Server database off the Project Server itself to a new
database server and it's doing fine and all is working. I noticed that we
have the Analysis Services Repository database installed on the Project
Server and I'm wondering if I need to move/migrate the data in there to the
new SQL server too? Looking int the Project Web Access Admin page under
Manage Enterprise features, I notice that we don't have any OLAP cubes built.
Can I take to mean there's no data in the Analysis Services Repository from
my Project Server? If I remove this database and then in the future build a
cube, will I have the option to specify the SQL server to put it on?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project server can't connect to the repository database 3
Analysis Services 4
Problem with creating Data Analysis View 3
PS2007 - OLAP Cube - Analysis Services 2005 3
2007 OLAP Cube building against SQL 2005 Cluster 2
Error: Cannot connect to the Analysis server on computer <server> 3
OLAP Cube build error 6
OLAP cube with SQL 2008 1

Top