Chapter 16 - Installing OLAP Services

  • Article

This section contains installation information for Microsoft SQL Server OLAP Services version 7.0. It also contains information to help you resolve problems that you may encounter.

Information 

  • System Requirements

  • Setup Options

  • Setup Parameters and Silent Installation

  • Verifying Installation

  • Removing OLAP Services 

  • Reinstalling OLAP Services

Related Documents 

The Readme.txt file in the \Install\ directory of the SQL Server compact disc contains detailed information pertaining to this release. Review Readme.txt before you install OLAP Services version 7.0.

If you install OLAP Services separately, you can copy or run SQL Server Books Online from the \Books\ directory on the SQL Server compact disc.

OLAP Services provides documentation about OLE DB, Microsoft ActiveX Data Objects (ADO), and ADO MD (Multidimensional) (ADO MD) in compiled HTML Help files. You can copy or run oledb200.chm and ado200.chm from the \MSOLAP\ directory on the SQL Server compact disc. If you copy these files, be sure to copy the associated index files (oledb200.chi and ado200.chi) to the same directory.

System Requirements

Before you can install Microsoft SQL Server OLAP Services version 7.0, your computer must meet the following requirements:

Hardware/Software

Requirements

Computer

DEC Alpha AXP and compatible systems
Intel or compatible (Pentium 133 MHz or higher, Pentium PRO, or Pentium II)

Memory (RAM)

32 megabytes (MB) minimum (64 MB recommended)

Disk drive

CD-ROM drive

Hard disk space1

35 - 50 MB (85 MB including common files and samples)

Operating system

Microsoft Windows NT Server 4.0 with Service Pack 4 or later2
Windows NT Workstation 4.0 with Service Pack 42
For client components only:
Microsoft Windows 95 + DCOM95
Windows 95 OSR2 + DCOM95
Windows 98

Network software

Windows NT, Windows 95, or Windows 98 built-in network software. Transmission Control Protocol/Internet Protocol (TCP/IP) (included with Windows).

Online Product Documentation Viewer

Microsoft Internet Explorer version 4.01 or later with Service Pack 13. You must install Windows NT 4.0 Service Pack 4 or later before you install Internet Explorer version 4.01.

Access Privileges

To install the services for OLAP server, you must be logged on to the server with Administrator privileges.

 

1 Setup installs a number of components that can be shared by other applications and may already exist on the computer. The Samples folder can be deleted after installation.

 

2 Windows NT Service Pack 4 is included on the SQL Server compact disc.

 

3 Internet Explorer is required for Microsoft Management Console (MMC) and HTML Help. A minimal installation is sufficient, and Internet Explorer does not need to be your default browser. Internet Explorer 4.01 with Service Pack 1 is included on the SQL Server compact disc.

For more information about supported hardware, see the Microsoft Windows Hardware Compatibility List at https://www.microsoft.com/windows/reskits/webresources/default.asp.

Setup Options

For important information about removing Microsoft SQL Server OLAP Services, see "Removing OLAP Services."

The complete setup for OLAP Services installs four separate components:

  • OLAP server (server binary executables and other server-related files). 

  • OLAP Manager (binary executables and other OLAP Manager-related files).

  • Client Components (client components and other related files). These component files are required to run the OLAP Manager and the OLAP server. 

  • Sample applications. These require the Client Components installation. 

  1. To install OLAP Services, double-click the Setup.exe file in the CD-ROM folder \MSOLAP\Install. The OLAP Services Setup program Welcome screen appears. Click Next to continue. 

    Note If you have installed a beta version of OLAP Services, Setup will not proceed until you remove it using the Add/Remove Programs application in Control Panel. 

  2. In the Software License Agreement screen, you must accept this agreement by clicking Yes. Otherwise, Setup will close.

  3. Enter your CD Key, which you receive when you purchase SQL Server, and then click OK. Confirm that the information displayed in the next dialog box is correct, and click OK again. 

  4. In the Choose Destination Location dialog box, you can change the destination. By default, OLAP Services is installed to the ..\Program Files\MSOLAP\ folder. If you change the default installation folder or drive, be sure to enter a fully qualified path name. Incorrectly entered paths and paths without drive letters may be misinterpreted by the Setup program. Click Next to accept the default installation path. 

    Note To avoid potential folder name conflicts, make sure there is no folder named Program in the root of the same drive as the Program Files folder, or choose a destination location other than the default location. 

  5. In the Choose Data Folder Location dialog box, you can change the location. By default, this location is ..\Program Files\OLAP Services\Data\. If you change the default data folder or drive, be sure to enter a fully qualified path name. Incorrectly entered paths and paths without drive letters may be misinterpreted by the Setup program. Click Next to accept the default data folder location. 

    If you want to install client components only, bypass this step by clicking Next. 

    To specify a data storage location other than the computer on which the server is installed, you must have full control access privileges on that computer. If you specify a data storage location other than the computer on which the server is installed, you must also configure your OLAP server service (MSSQLServerOLAPService) to log on as your user account, instead of the default, which is to log on as the system account. To configure the OLAP server to do this:

    1. On the Microsoft Windows desktop, click Start, point to Settings, click Control Panel, and then double-click Services. 

    2. In the Services dialog box, double-click MSSQLServerOLAPService. 

    3. In the Service dialog box, under Log On As, click This Account. 

    4. Enter your local user account name in the text box. 

    5. Confirm your password in the boxes beneath your user name. 

    6. Click OK. 

  6. All of the options in the Select Components dialog box are selected by default. Click OK to install all components. We recommend that you install all program default options. (If you do not want to install a particular item, clear its check box and then click Next to install the remaining items.) 

  7. In the Select Program Folder dialog box, accept the default startup folder name or enter a new folder name. Click Next. 

  8. Setup will notify you when the files have been installed. If you are prompted, you should restart your computer to complete the installation. 

Setup Parameters and Silent Installation

The Setup program (\MSOLAP\Install\setup.exe) can be launched with the following optional command line parameters:

-r causes Setup.exe to automatically generate a silent response file (.iss), which is a record of the installation input, in the default Microsoft Windows folder.

-s performs a silent (unattended) installation.

-f1<path\ResponseFile> The alternate location and name of the response file (.iss file) can be specified using this option. If the -f1 switch is not used when you run silent installation, Setup looks for the response file Setup.iss in the same folder as Setup.exe.

-f2<path\LogFile> The alternate location and name of the log file can be specified by using this option. By default, the Setup.log log file is created and stored in the same folder as that of Setup.exe.

If you use the -r option you can create a record of any desired installation scenario. You can use this record to perform a silent installation. For example, the command

Setup.exe -s -f1C:\temp\setup.iss

initiates a silent (unattended) installation of the components specified in the setup.iss response file previously recorded when you used the -r option.

Verifying Installation

You can verify that Microsoft SQL Server OLAP Services has been correctly installed and started by performing the following steps:

  1. On the Microsoft Windows desktop, click Start, point to Settings, click Control Panel, and then double-click Services. 

  2. Locate MSSQLServerOLAPService in the list. The status should be "Started" and the startup should be "Automatic." 

  3. Click Stop to stop the service, and then click Start. The status should be "Started" and the startup should be "Automatic." 

Removing OLAP Services

Removing Microsoft SQL Server OLAP Services will delete the repository file (msmdrep.mdb) which contains cube metadata. We recommend that you make a backup copy of this file before you remove OLAP Services. After installation, you will need to reprocess all defined cubes to re-create the cube data files.

If you intend to remove and then reinstall OLAP Services, you must restart your computer before starting the reinstallation. The removal process marks some files for deletion the next time the computer starts; these files must be removed before the next installation replaces them.

If the removal process fails to complete successfully, install OLAP Services again, and then restart the removal process. You may have to manually delete remaining files and folders after running the Add/Remove Programs application in Control Panel.

Reinstalling OLAP Services

To reinstall Microsoft SQL Server OLAP Services, return to "Setup Options" and follow the steps outlined.

Note Reinstalling OLAP Services will not delete the repository file (msmdrep.mdb), which contains cube metadata. However, you will need to reprocess all dimensions and cubes after the reinstallation.