New UR’s for SC 2012 R2 & SP1, Updated Exchange 13 MP & more

Wow another exciting day for Microsoft and specifically System Center! Microsoft is moving at a fast pace and doing some cool things. There were several announcements today. These included:

Update Rollup 4 for System Center 2012 R2

http://aka.ms/yktkfk

App Controller is not included in this. I am not surprised by this. Configuration Manager and Orchestrator do not have any fixes or new features either. The rest include:

Service Manager
Data Protection Manager
Operations Manager
Service Provider Foundation
Virtual Machine Manager
Service Reporting
Windows Azure Pack
Windows Azure Pack Web Sites Version 2

It is interesting to see Windows Azure Pack included with the System Center update rollup. Also DPM has been getting a lot of love from the DPM team at Microsoft...

Read More

DPM 2012 R2 Upgrade unable to connect SSRS. ID: 33431

I recently had to help someone do a DPM upgrade from DPM 2012 SP1 UR3 to DPM 2012 R2. I am a fan of starting fresh when I can but in this case we had no choice but to do an upgrade. We had to first upgrade SQL 2008 R2 to SQL 2012. After upgrading to SQL 2012 and trying to run the DPM upgrade we got the following error regarding SSRS:

“DPM Setup is unable to connect to the specified instance of SQL Server Reporting Service. (ID: 33431)”

clip_image001.png

What is happening is that the DPM installer is trying to access the 2008 R2 SSRS even though it no longer exists as SQL has been upgraded to 2012. I manually removed the left over SQL 2008 components and rebooted but this did not help. The DPM installer uses WMI to get information about the SSRS installation during the install, so in order to fix this I had to go into WMI and remove the SQL 2008 references. Here are the steps:

Open the WMI tool:

From the Run window type: wbemtest

clip_image002.png

In the namespace type the following:

\\NAMEOFYOURDPMSERVERGOESHERE\root\Microsoft\SqlServer\ReportServer\RS_NAMEOFYOURSQLINSTANCEGOESHERE

clip_image003.png

You will now be connected. Click on Query.

clip_image004.png

Put in the following query:

SELECT * FROM __NAMESPACE

clip_image005.png

You will then see two entries for SSRS that DPM is trying to access. You will see one for v10 and one for v11.

v10 is for SQL server 2008 R2 and v11 is for SQL 2012. We want the DPM installer to connect to SSRS on SQL 2012.

Click the Apply button in the query window and you will see the results.

clip_image006.png

Highlight v10 and click the Delete button. Now click Close and click Exit to close out the WMI tool.

Now run the DPM 2012 R2 upgrade again and it should go through without any issues.

DPMSSRSerror1

Read More

Speaking @ MMS as one of the 3 International System Center Chefs

I am excited to be co-presenting a Service Manager session at MMS 2014 on November 10th. The Midwest Management Summit is a 3-day conference purposely capped to just 500 attendees so that nobody gets lost in the crowd. Almost 60 Microsoft MVP’s will be presenting on System Center topics and more.

Areas the speakers will be presenting on are Operations Manager, Configuration Manager, Orchestrator, Service Management Automation, Service Manager, Data Protection Manager, Azure Pack, PowerShell, Desired State Configuration and more.

The session I will be co-presenting in is titled: 900 Degrees of Service Manager with 3 International System Center Chefs. I am lucky to be co-presenting with:

image

image

Here is what you can expect from the session:

“In this demo-packed session, you explore the depths of customizing Service Manager with Samuel Erskine, Dieter Gasser and Steve Buchanan (MVP). We will walk you through real-world scenarios of using advanced customization techniques such as the Authoring Tool, PowerShell, and Visual Studio to build and customize classes, forms, workflows and console tasks in Service Manager. We also discuss best practices, recommendations and processes you follow when customizing Service Manager. You will learn how to plan for customizing Service Manager for business processes. Transform your plans into custom solutions using the advance authoring tools. Finally the session is delivered by 3 deep experts with vast real world deployment and authoring experience.”

Here is a video from the MMS site with us talking about the session:

image

About me:

image

Full details about this session can be found here: 900 Degrees of Service Manager with 3 International System Center Chefs

UPDATE:

MMS has extended reduced conference registration until Friday, October 17th. So go and register today to keep from paying the higher conference and hotel rates!

Read More

Hot off the press: Service Manager 2012 Unleashed book

The System Center 2012 Service Manager Unleashed book is finally done! I received some copies of it on Friday. It is set to publish on Monday October 6th 2014. Here is the link for it and a picture below.

http://www.amazon.com/System-Center-Service-Manager-Unleashed/dp/067233707X

SCSM 2012 Unleashed

There was a great team of people behind this book consisting of well-known folks in the Service Manager community from MVP’s, MCT’s, expert consultants, and even Microsoft staff. Authors included me, MVP Kerrie Meyler, MVP Kurt Van Hoecke, and MCT Sam Erskine. Contributors include MVP Jakob Svendsen, Microsoft employee Kathleen Wilson, MCT Kenneth Surksum, Oskar Landman, MVP Patrik Sundqvist, and Peter Quagliariello. Even the foreword was done by former Microsoft program manager and now MVP Christian Booth and Service Manager program manager Srikanth Ranganathan.

This book is packed with tons of “why” and “how to” content for Service Manager. If you have Service Manager deployed or you are about to embark on a Service Manager project add this book to your library. Here is an overview of the content in the book:

This comprehensive resource will help you automate and optimize all facets of service management with System Center 2012 Service Manager.

Expert consultants offer deep “in the trenches” insights for improving problem resolution, change control, release management, asset lifecycle management, chargeback, and more. You’ll learn how to implement high-value best practices from ITIL and the Microsoft Operations Framework.

The authors begin with an expert overview of Service Manager, its evolution, and its new capabilities. Next, they walk through overall planning, design, implementation, and upgrades. Then, to help you focus your efforts, they present stepwise coverage of all topics in each feature area, linking technical information about Service Manager with essential knowledge about the technologies it depends on.

Whatever your role in deploying or running Service Manager, this guide will help you deliver more responsive support at lower cost and drive more value from all your IT investments.

• Leverage MOF and ITIL processes built into System Center 2012 Service Manager
• Plan and design your Service Manager deployment
• Install Service Manager or upgrade from earlier versions
• Efficiently administer work and configuration items
• Use connectors to integrate with Active Directory, Exchange, and System Center components
• Create service maps
• Enable end user access through Service Manager’s self-service portal
• Implement incident, problem, change, and release management
• Utilize workflows to automate key support processes
• Create service level agreements with calendars, metrics, and objectives
• Provide quick access to a standardized catalog of services
• Use notification to ensure that Service Manager items are promptly addressed
• Secure Service Manager and its data warehouse/reporting platform
• Perform maintenance, backup, and recovery
• Manage Service Manager performance
• Customize Service Manager

http://www.amazon.com/System-Center-Service-Manager-Unleashed/dp/067233707X

Read More

SCORCH Web Console Error Executing the current operation

When I tried to access my Orchestrator 2012 R2 web console @ https://localhost:82 I was receiving the following error:

Error Executing the current operation [HttpWebRequest_WebExeption_RemoteServer] Arguments: NotFound Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem.

clip_image001

My Orchestrator web service (http://localhost:81/Orchestrator2012/Orchestrator.svc) still worked just fine.

I did a search online and most of what I found pointed to this issue occurring after an Orchestrator upgrade. In my case this was a fresh Orchestrator install. I also checked the IIS connection string for the Orchestrator web console. It was fine.

I was able to resolve this. Here is what I did:

In IIS go to the application pools.

clip_image002

Read More

SCOM Cannot initialize report after DB move

After moving the SCOM database, DW database and Reporting database to a SQL 2012 cluster I was no longer able to run reports. I would get a Cannot initialize report error as shown in the following screenshot.

clip_image001

More of the error:

Microsoft.Reporting.WinForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) —> Microsoft.Reporting.WinForms.ReportServerException: Cannot create a connection to data source ‘DataWarehouseMain’. (rsErrorOpeningConnection) —> Microsoft.Reporting.WinForms.ReportServerException: Cannot open database "OperationsManagerDW" requested by the login. The login failed.

To fix this I did the following:

#1 Checked the user mappings on the ReportServer database per step 14 on this link:

http://technet.microsoft...

Read More

Point SCSM DW & WAP Request Management to new SQL server

I recently worked with a client that hosted the Service Manager database on a SQL cluster. They manually failed over the SCSM database to the other node in the SQL cluster. Request Management in Azure Pack and the SCSM data warehouse were still trying to communicate with Service Manager using the old node in the SQL cluster. We needed a way to manually flip both Azure Pack and The DW over to the new node in the SQL cluster. Below is how I did this. I am posting about this in case it saves anyone else time and for me if I need it for future reference.

GridPro Request Management in Windows Azure Pack Failover:

Navigate to: C:\inetpub\MgmtSvc-RequestManagementAPI

Open the “solidConnectionSettings.config” file in a text editor such as notepad.

Modify the highlighted value in the connection string to the name of the second node in the SQL cluster:

<connectionStrings>

<add name=”ServiceManagerCMDB” connectionString=”Server=SQLSERVER1,1433;Database=ServiceManager;Integrated Security=True”/>

</connectionStrings>

After this is modified an IIS reset is needed. After that the Request Management in Windows Azure Pack should now attempt to connect to Service Manager on the correct SQL node.

Service Manager Data Warehouse failover:

In regards to the data warehouse we needed to re-point this to the second node in the SQL cluster. To do this I:

Opened the DWStagingAndConfig database.

Open the MT_Microsoft$SystemCenter$ResourceAccessLayer$SqlResourceStore table.

And

Run Select * from MT_Microsoft$SystemCenter$ResourceAccessLayer$SqlResourceStore

Or

Right click on the table and Select Top 1000 rows. (Don’t worry there are only 10 rows in this table.)

clip_image001.png

Note the 5th row column DataService_98B2DDF9_D9FD_9297_85D3_FCF36F1D016B has Service Manager listed. Further along in row 5 under column Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA it has the SQL server for Service Manager that it is pointed to listed. This is what needs to be changed. You can see this in the following screenshot:

clip_image002.png

To change this run the following:

UPDATE MT_Microsoft$SystemCenter$ResourceAccessLayer$SqlResourceStore

SET Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA = ‘SQLSERVER2′

WHERE DataService_98B2DDF9_D9FD_9297_85D3_FCF36F1D016B = ‘ServiceManager’

NOTE: Be sure to replace SQLSERVER2 with the name of your new SQL node.

Now if you Run Select * from MT_Microsoft$SystemCenter$ResourceAccessLayer$SqlResourceStore

You will see row 5 in the Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA column will reflect the change.

clip_image003.png

Thanks to SCSM Master and Concurrency co-worker Steve Seibold for help tracking down th...

Read More

Online Orchestrator Clinic

The Windows Management User Group (WMUG.co.uk) – @WMUG presents the August 2014 Clinic in which System Center Orchestrator will be discussed with Sam Erskine (@samerskine) and a team of Orchestrator Guru’s. The team includes:

Steve Beaumont (MVP) – @StevybSC
Dieter Gasser@DiGaBlog
Steve Buchanan (MVP) – @Buchatech
Andreas Baumgarten (MVP) – @ABaumgarten

Sam Erskine has co-authored books on the subject as well as consulting in the deployment of Orchestrator for ITSM.

Details for the Event:

The event is held using Lync Online at 8PM BST on the 20th of August 2014.
Check your time zone here: http://www.timeanddate.com/worldclock/converter.html

You can join the live session on the 20th off August 2014: https://meet.lync.com/smsmarshall/rob/D343FYNB

Attendee link is her...

Read More

MVP Unplugged at TechED Video

Savision just released a video they put together of interviews with several MVP’s from TechEd NA 2014. MVP’s in the video include:

  • Robert Butler’
  • Cameron Fuller
  • Kevin Greene
  • Ahmed Nabil Mahmoud
  • Rick Heiges
  • Colin Smith
  • and me

The video was to gather our opinions on the following topics:

  • System Center & VMM
  • Security Concerns in the Cloud
  • The Future of IT
  • Savision solutions

You can watch it here: http://www.savision.com/resources/news/watch-video-mvps-unplugged-teched-na-2014.

clip_image001.png

Thanks Savision for the opportunity to be a part of the video and for supporting community!

Read More

Microsoft Private & Public Cloud Poster

On August 1st Microsoft released a new Cloud Ecosystem poster. Microsoft has a great Public and Private cloud story. With Microsoft technologies On-premises and public Azure and other Microsoft public cloud technologies such as Intune are really tied together. Microsoft Private and Public cloud consist of Windows Server 2012 R2, System Center 2012 R2 and Microsoft Azure. This new poster gives you a good visual reference for understanding these technologies and what role they play in the overall cloud story.

Here is a preview of what the poster looks like:

image

Here is the official description for the poster:

This document provides a visual reference for understanding key Microsoft private cloud and on-premises cloud technologies. This poster includes information about:

  • Microsoft Azur...
Read More