Hello Experts,

We are finally upgrading from SCOM 2007 R2 to SCOM 2012 R2. Currently we have our DB's on SQL 2008 R2. I would like to know if the SCOM DB is compatibility with SQL 2014.

Thanks in Advance.

Regards,

Prajul Nambiar

Hi,

SQL2014 is not supported

SQL Server Requirements for System Center 2012 R2

https://technet.microsoft.com/library/dn281933.aspx

SCOM 2012 R2 currently is not official support SQL 2014. It is strong recommend that do not use SQL 2014 in SCOM production environment although my testing environment , with SQL 2014 as DB server, work fine.

Roger

• Proposed as answer by Yan Li_Microsoft contingent staff, Moderator Thursday, February 19, 2015 5:10 AM
• Marked as answer by Yan Li_Microsoft contingent staff, Moderator Sunday, February 22, 2015 8:08 AM

Hi,

With UR5 SQL2014 is now supported

Support for SQL Server 2014 with System Center 2012 R2 Update Rollup 5

http://blogs.technet.com/b/systemcenter/archive/2015/02/23/support-for-sql-server-2014-with-system-center-2012-r2-update-rollup-5.aspx