Database Reference
In-Depth Information
During the installation of SQL Server 2008 R2 features, windows installer creates temporary
files on the system drive. It is essential to ensure that you have at least 4 GB of available
disk space on the system drive for these temporary files. Finally, the actual hard disk space
requirements depend on your system configuration and the features that you decide to install.
For SQL Server Analysis Services and data files, the minimum disk space requirement is
476 MB.
Getting ready
In order to prepare for the installation of SQL Server Analysis Services, you need to ensure
that you have the following in place:
F
.NET Framework 3.5 Service Pack 1: It helps improvements in the area of data
platform, such as ADO.NET Entity Framework, ADO.NET data services and support for
new features of SQL Server 2008 version onwards.
You can download .NET Framework 3.5 Service Pack
1 from
http://www.
413d-8319-81da479ab0d7&displa
ylang=en
.
F
Windows Installer 4.5: It helps the application, installation, and configuration
service for Windows. It works as an embedded chainer to add packages to a multiple
package transaction. The major advantage of this feature is its ability to enable an
update to add or change custom action, so that the custom action is called when an
update is uninstalled.
You can download Windows Installer 4.5 redistributable pack
age from:
The SQL Server setup support files installs SQL Server Native Client and contains SQL OLEDB
provider and SQL ODBC driver as a native Dynamic Link Library (DLL). These DLL's support
applications using native code APIs to SQL Server.
To install Analysis Services in SharePoint Integrated mode, SQL Server 2008 R2 Setup
includes a new Server installation option for installing PowerPivot for SharePoint, so that it
is immediately available when the setup is finished. To use this option, you must start with a
clean server that has SharePoint 2010 installed but not yet configured.
More importantly, it allows the SQL Server Setup to configure SharePoint by using those
settings that are optimal for PowerPivot query processing and server management. In this
recipe, we will install PowerPivot for SharePoint prerequisites and run server setup. If you are
installing Analysis Services on the existing SharePoint Server, then it is common to configure
the server immediately after you install it.
Search WWH ::
Custom Search