SCSM Reporting: Dataset for Incident Requests

It’s Christmas time again, and that means it’s time for another SQL query for Service Manager reporting.

Category: Service Manager, SQL and System Center  |  2 Comments

Troubleshooter note: SQL Installation fails with exitcode 0x84BB0001 on a ReFS formatted partition.

So I tried to install SQL the other day for a new ConfigMgr environment, but I kept getting an error during the first seconds of the installation with 0x84BB0001 as the exit code. With some quick investigation into the log files I found this %Temp%\SqlSetup_Local.log: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\Summary.txt: Shows that the installation has […]

Category: Config Mgr, Configuration Manager, Configuration Manager 2012, Home, Microsoft SQL, Scripting, SQL and System Center, SQL Scripts  |  Comment

SCOM 2012 R2 and SQL Server 2014

**** This is not supported by Microsoft and should only be done in a Test Environment **** *** Not even in the staging environment – Please *** Some customers have asked me about the gain for using SQL 2014 in the SCOM environment – And I did some fast tests – In my test envronment […]

Category: Operations Manager 2012 R2, SCOM R2 Installation, SQL and System Center  |  1 Comment