Installing Analysis Services

You need to know a few things about installing Analysis Services. We are not going to go through the screens, because they're pretty much self-explanatory.

Suppose you want to install a default instance of SQL Server 2005 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 2005 Named Instance. Then you can install another instance of SQL Server 2005 as the default instance.

Remember that SQL Server 2005 Analysis Services does not support SQL Collations. You can get weird behavior if your Database Engine Collation is a SQL collation and Analysis Services is a Windows collation.