2.3. Installing Analysis Services
We are not going to go through the screens for installing Analysis Services because they're pretty much self-explanatory. However, you should be aware of a few details.
Suppose you want to install a default instance of SQL Server 2008 Analysis Services on a box that already has an instance of SQL Server 2000 Analysis Services. SQL Server 2000 Analysis Services does not support named instances, so if you have SQL Server 2000 Analysis Services on your install box, you must upgrade the SQL Server 2000 Analysis Services install to a SQL 2008 named instance. Then you can install another instance of SQL Server 2008 as the default instance. You'll learn more about Analysis Services in Chapter 7.
Remember that SQL Server 2008 Analysis Services does not support SQL collations. You can get weird behavior if your Database Engine collation is a SQL Server collation and Analysis Services is a Windows collation.
Get Professional Microsoft® SQL Server® 2008 Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
