Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
About the Author
About the Reviewers
More DBA Manageability Best Practices

Preparing and installing SQL Server Analysis Services

SQL Server provides a way to install any or all of its components including Analysis Services. The planning and architecture is an important aspect to better understand Analysis Services multi-dimensional database and plan how to implement the multi-dimensional database into your business intelligence solution.

In this recipe, we will evaluate the Analysis Services installation options and SQL Server PowerPivot for SharePoint. These evaluation steps also include the best practice hardware/software requirements, configuration, and security considerations for the installation. The topics highlight the important considerations that you should be aware of before you install Analysis Services. Note that many BI solutions require the installation of additional SQL Server components to enable the development, deployment, administration, and management of Business Intelligence suite.

During the installation of SQL Server 2008 R2 features, windows...