How to Configure SQL Server Analysis Services for VMM
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Virtual Machine Manager, System Center 2012 R2 Virtual Machine Manager, System Center 2012 - 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.
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
In the VMM console, open the Settings workspace.
In the Settings pane, click System Center Settings, and then click Operations Manager Server.
On the Home tab, in the Properties group, click Properties to open the Operations Manager Settings dialog box.
On the SQL Server Analysis Services page, click Enable SSAS.
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.
Make sure that SQL Server Reporting Services allows reports access using default port 80 and has HTTP access to reports.
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.