Pre-Installation Options for Analysis Services in SQL Server 2008

Some time back I published a post on post-installation steps for Analysis Services. That post was written with SQL Server 2005 in mind. In SQL Server 2008 – Data Dir, Log File Dir, Temp dir and Backup dir can now be specified as a step BEFORE installation of Analysis Services. There is no need for post-installation steps in SQL Server 2008, unless you missed configuring this step during installation. Continue Reading

Minimal Post-Installation Steps for Analysis Services

installDuring installation of Analysis Services, most of the properties are configured with a default value. These properties can be reconfigured any time after installation from SQL Server Management Studio. For most properties the default values works just fine. However, there are few properties that are best reconfigured immediately after installation to prevent down-time in production environment. Continue Reading