SQL Server 2005 and Analysis Service 2005 upgrade
Hi, All,
I posted this question onhttp://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us andhttp://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=211308, but only got 1 response so far. So I am trying here.
Our IT department is planning for the SQL Server/Analysis Service upgrade next year. For budgeting reason, management may want to hold the upgrade of Analysis Service to a later date, after the SQL Server is upgraded to 2005. We store Analysis Service repository in SQL Server databases. Both SQL Server and Analysis Service instances are on the same server. Although we would like to upgrade both components at the same time, we are curious to know if there will be problems if we use SQL Server 2005 database as the repository for Analysis Service 2000. Any insight will be appreciated.
Thanks
Liping

