Configuring SQL Analysis Services for Virtual Machine Manager 2012 SP1 with Static Port Resulted in an Error


Reporting in System Center 2012 Virtual Machine Manager is achieved trough the integration with OpsMgr 2012. In order to run some of the VMM reports that have forecasting you have to configure the VMM to SCOM integration to use SQL Analysis Services instance. This instance should be the same instance with Reporting Services for SCOM. So I’ve installed SQL Analysis Services on the same instance with Reporting Services for SCOM. It is not the default instance on the server so I’ve configured SQL Analysis Services to use a specific static port instead of using a dynamic one (I like using static ports for SQL servers Smile ). I’ve opened the VMM console. Went to settings, than System Center settings and I’ve opened the properties of Operations Manager Server. Click on the SQL Server Analysis Services tab and entered the SQL server name, the SQL instance, the port that I had set and the credentials to connect. To my surprise I’ve received and error to my surprise I’ve received an error message:

The SQL Server Analysis Server %ComputerName; is not reachable.

I’ve opened CMD and checked if there is a connection to the SQL server and the port via Telnet. Connection was OK. Than I’ve replaced the port with 0 and connection was successful. SQL Analysis Services were configured successfully. To me this is a bug and I will try to log it.

image

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.