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

How to Configure SQL Server Analysis Services for VMM

Updated: January 22, 2014

Applies To: System Center 2012 - Virtual Machine Manager, System Center 2012 R2 Virtual Machine Manager, System Center 2012 SP1 - Virtual Machine Manager

You can integrate Virtual Machine Manager (VMM) with SQL Server Analysis Service (SSAS) in order to provide forecasting reports. Be sure that SQL Analysis Services are installed on the Operations Manager Reporting server.

Before you enable SSAS, you need to connect to an Operations Manager management server, as described in How to Connect VMM with Operations Manager. Also, before you use SSAS, it is strongly recommended that you apply the latest Update Rollup for VMM that is available from Microsoft Support.

ImportantImportant
SSAS requires Analysis Management Objects (AMO) be installed on the VMM management server. To download AMO, see the Microsoft SQL Server 2008 Feature Pack, Microsoft SQL Server 2008 R2 Feature Pack, or Microsoft SQL Server 2012 Feature Pack.

Account requirements You must be a member of the Administrator user role to configure SSAS.

To configure SQL Server Analysis Service

  1. In the VMM console, open the Settings workspace.

  2. In the Settings pane, click System Center Settings, and then click Operations Manager Server.

  3. On the Home tab, in the Properties group, click Properties to open the Operations Manager Settings dialog box.

  4. On the SQL Server Analysis Services page, click Enable SSAS.

  5. Enter the SSAS server, SSAS instance, and SSAS Port.

    The instance name must be the same as the SQL Server Reporting Services, by default MSSQLSERVER.

    The default port is 0.

    ImportantImportant
    Make sure that SQL Server Reporting Services allows reports access using default port 80 and has HTTP access to reports.

  6. Select either a Run As account or enter a user name and password, and then click OK.

    This user must belong to the Operations Manager Report Security Administrator profile.

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.