Month: October 2015

SCOM 2012 R2 – Data Warehouse Service Account is not allowed to access Data Warehouse database

  Well today I logged into a customer’s site to deal with a SCOM issue in there SCOM 2012 R2 environment. The SCOM environment itself appeared to be working, but the data warehouse wasn’t being populated. This occurred as they changed the service accounts from a Local Service to best practices of using domain accounts. The following events were constantly repeated through the Operations Manager event log (Applications and Services Log/Operations Manager)   Event ID: 31551 Provider Name: “Health Service Modules” Task Category Data Warehouse Time: 13:03 Failed to store data in the Data Warehouse. The operation will be retried. Exception ‘SqlException’: Management Group with id ”ABCDEFAB-ABAB-1234-4567-ABCDEFABCDEF” is not allowed to access Data Warehouse under login ”DOMAIN\svc-ScomDW”One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectEventData Instance name: scom01.someCompoany.com Instance ID: {12312312-3434-4545-5656-123456789012} Management group: SCOM-MGMTGROUP Event ID: 31569 Provider Name: “Health Service Modules” Task Category Data Warehouse Time: 13:02 Report deployment process failed to request management pack list from Data Warehouse. The operation will be retried. Exception ‘SqlException’: Management Group with id ”ABCDEFAB-ABAB-1234-4567-ABCDEFABCDEF” is not allowed to access Data Warehouse under login ”DOMAIN\svc-ScomDW” One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report Instance name: Data Warehouse Synchronization Service Instance ID: {12312312-3434-4545-5656-123456789012} Management group: SCOM Management Group Event ID: 31557 Provider Name: “Health Service Modules” Task Category Data Warehouse Time: 13:01 Failed to obtain synchronization process state...

Read More

Windows Azure Pack (WAP) Site to Site VPN (S2SVPN) with Cisco ASA

Problem I’ve run into an issue when a customer was using a Cisco ASA 5515 to connect into our WAP deployment. Cisco is a big player in the networking market and one would think that connecting a device such as this to a Windows Server Gateway (WSG) WAP S2SVPN would be straight forward. Reason There are a few key implementation differences with how the WSG and Cisco ASA implement IKEv2. As WSG uses RRAS under the hood, we have to look at how RRAS works. Currently RRAS is configured to send an IKEv2 tunnel with a Traffic Selector of...

Read More

MVPLogo

Vanguard

MVPLogo

MVPLogo