November 13, 2008 at 10:20 am
Good morning. We have a request from a user to upgrade ONLY Analysis Services from sql server 2000 to 2005 and leave the rest running in 2000. Do anyone know if this is possible? It doesn't sound right to me - but, I want to be sure.
Thanks!
November 13, 2008 at 10:46 am
schep021 (11/13/2008)
Good morning. We have a request from a user to upgrade ONLY Analysis Services from sql server 2000 to 2005 and leave the rest running in 2000. Do anyone know if this is possible? It doesn't sound right to me - but, I want to be sure.Thanks!
SSAS runs on a separate instance from other services - db engine, SSIS, SSRS - so you should be able to upgrade it on its own. However, you do need to test whether doing so will cause any problems accessing data on the SQL 2000 db-engine instances, creating cubes etc.
I'm tempted to say there should be no issues if you upgrade just SSAS to sql 2005.
But you need to test.
Perhaps someone else out there has a more informed opinion.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply