O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required