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 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.