We are pleased to announce that System Center 2012 R2 Operations Manager (OpsMgr 2012 R2) now supports
SQL Server 2014 Enterprise, Standard (64-bit)
as its database. If you choose to use SQL 2014, below are a couple known issues and workarounds you’ll want to be aware of.
: Installation to a SQL 2014 cluster using Cluster Shared Volumes (CSV) is blocked by SCOM 2012 setup.
: Deploy to a physical server and then use the documentation
to move the database to the CSV.
: Upgrade of SQL SRS is blocked due to SCOM 2012 use of Custom Security Extensions.
: Uninstall SCOM Reporting and run
to clear the custom security extensions. Once that is complete, upgrade SQL and install SCOM 2012 reporting again. Can find similar steps in the documentation