Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Managing Analysis Services Instances

Managing an instance of Microsoft SQL Server Analysis Services consists of managing the Analysis Services service itself, setting Analysis Services configuration properties, managing data storage by using local and remote partitions, backing up and restoring, and ending user activity when needed.

Microsoft SQL Server Analysis Services uses some or all the following services:

  • Analysis Services   Each instance of Analysis Services is itself a Microsoft Windows service, and can be managed like any other service.

  • Microsoft SQL Server   Each instance of SQL Server is itself a Microsoft Windows service, and can be managed like any other service.

  • SQL Server Agent   SQL Server Agent is a Microsoft Windows service that makes automating SQL Server tasks possible. Each instance of SQL Server has a separate instance of SQL Server Agent. For more information about SQL Server Agent, see Automating Administrative Tasks (SQL Server Agent).

  • SQL Server Browser   SQL Server is a Microsoft Windows service that includes the Analysis Services redirector service. The Analysis Services redirector service is responsible for directing clients to named instances of Analysis Services. There is only one instance of this service on a computer, regardless of the number of Analysis Services instances.

These support services must be configured and managed so that Analysis Services operates correctly within your environment. To start, stop, pause, or reconfigure any Microsoft Windows service on the computer that is running SQL Server Analysis Services, the Analysis Services administrator must be a member of the Administrators local group on the computer.

Security noteSecurity Note

A member of the Administrators local group controls permissions on the Analysis Services computer and can perform any task on that computer, such as reading the data stored in any Analysis Services instance on the computer.

The following topics provide more information about how to manage the Microsoft Windows services used by Analysis Services:

Configuring Services at the Operating System Level

Describes the properties to be configured for use of an Analysis Services instance.

Starting and Stopping Services

Describes when administrators start, pause, or stop an instance of Analysis Services.

Reviewing Service Management Tools

Describes the different ways you can start, pause, or stop an Analysis Services instance.

Setting Server Configuration Properties

Describes how to configure properties for Analysis Services.

Managing Multiple Instances of Analysis Services

Describes the correct use of ports and SQL Server Browser to work with multiple instances of Analysis Services.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.