Tag: SQL

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

Guide to SQL Server Maintenance Plan

When dealing with System Center components you also have to deal with SQL. Some SC specialist are more advanced with SQL others not. Every SQL server needs at least some basic maintenance. For those who are not familiar with some of the maintenance tasks in SQL there is one good guide that will help you.

Orchestrator Integration Pack for MSSQL Tasks 1.1

One more free IP for SC Orchestrator updated by Charles Joy. Download it from here.

Thank you Charles for providing integration packs for the community.

Tips on planning SQL for System Center 2012

I think many of us have faced the challenge to make the design of SQL for their System Center components. Even though we have knowledge of SQL at some certain level we are not hardcore experts in it. Thanks to Paul Keely a Microsoft MVP we now have some guides on dealing with SQL for System Center. You can download his guide

“SQL Server guide for System Center 2012” which for SQL 2008 R2 but there is no reason to use the same tips for SQL 2012.

Hyper-V and SQL 2012 – better together

Microsoft gave the task to Enterprise Strategy Group (ESG) to make Workload Performance Analysis of using Microsoft Windows Server 2012 with Hyper-V and SQL Server 2012. Findings of this report you can find in this article.