OpsMgr 2012 R2 now offers additional support for SQL Server

Published Feb 16 2019 12:20 AM 66 Views
First published on TECHNET on Feb 23, 2015

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.

Issue : Installation to a SQL 2014 cluster using Cluster Shared Volumes (CSV) is blocked by SCOM 2012 setup.
Workaround : Deploy to a physical server and then use the documentation here to move the database to the CSV.

Issue : Upgrade of SQL SRS is blocked due to SCOM 2012 use of Custom Security Extensions.
Workaround : Uninstall SCOM Reporting and run ResetSRS.exe 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 here .

Suraj Suresh Guptha | Program Manager | Microsoft

Get the latest System Center news on Facebook and Twitter :

Main System Center blog: http://blogs.technet.com/b/systemcenter/

Configuration Manager Support Team blog: http://blogs.technet.com/configurationmgr/
Data Protection Manager Team blog: http://blogs.technet.com/dpm/
Orchestrator Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
Virtual Machine Manager Team blog: http://blogs.technet.com/scvmm

Microsoft Intune: http://blogs.technet.com/b/microsoftintune/
WSUS Support Team blog: http://blogs.technet.com/sus/
RMS blog: http://blogs.technet.com/b/rms/
App-V Team blog: http://blogs.technet.com/appv/
MED-V Team blog: http://blogs.technet.com/medv/
Server App-V Team blog: http://blogs.technet.com/b/serverappv

Forefront Endpoint Protection blog: http://blogs.technet.com/b/clientsecurity/
Forefront Identity Manager blog: http://blogs.msdn.com/b/ms-identity-support/
Forefront TMG blog: http://blogs.technet.com/b/isablog/
Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/
Application Proxy blog: http://blogs.technet.com/b/applicationproxyblog/
The Surface Team blog: http://blogs.technet.com/b/surface/

%3CLINGO-SUB%20id%3D%22lingo-sub-350274%22%20slang%3D%22en-US%22%3EOpsMgr%202012%20R2%20now%20offers%20additional%20support%20for%20SQL%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-350274%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Feb%2023%2C%202015%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F82101iA0575EFF6AFD44D2%22%20%2F%3E%20We%20are%20pleased%20to%20announce%20that%20System%20Center%202012%20R2%20Operations%20Manager%20(OpsMgr%202012%20R2)%20now%20supports%20%3CSTRONG%3E%20SQL%20Server%202014%20Enterprise%2C%20Standard%20(64-bit)%20%3C%2FSTRONG%3E%20as%20its%20database.%20If%20you%20choose%20to%20use%20SQL%202014%2C%20below%20are%20a%20couple%20known%20issues%20and%20workarounds%20you%E2%80%99ll%20want%20to%20be%20aware%20of.%3C%2FP%3E%0A%20%20%3CP%3E%3CSTRONG%3EIssue%20%3C%2FSTRONG%3E%20%3A%20Installation%20to%20a%20SQL%202014%20cluster%20using%20Cluster%20Shared%20Volumes%20(CSV)%20is%20blocked%20by%20SCOM%202012%20setup.%20%3CBR%20%2F%3E%20%3CSTRONG%3EWorkaround%20%3C%2FSTRONG%3E%20%3A%20Deploy%20to%20a%20physical%20server%20and%20then%20use%20the%20documentation%20%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fhh278848.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20here%20%3C%2FA%3E%20to%20move%20the%20database%20to%20the%20CSV.%3C%2FP%3E%0A%20%20%3CP%3E%3CSTRONG%3EIssue%20%3C%2FSTRONG%3E%20%3A%20Upgrade%20of%20SQL%20SRS%20is%20blocked%20due%20to%20SCOM%202012%20use%20of%20Custom%20Security%20Extensions.%20%3CBR%20%2F%3E%20%3CSTRONG%3EWorkaround%20%3C%2FSTRONG%3E%20%3A%20Uninstall%20SCOM%20Reporting%20and%20run%20%3CSTRONG%3E%20%3CEM%3E%20ResetSRS.exe%20%3C%2FEM%3E%20%3C%2FSTRONG%3E%20to%20clear%20the%20custom%20security%20extensions.%20Once%20that%20is%20complete%2C%20upgrade%20SQL%20and%20install%20SCOM%202012%20reporting%20again.%20Can%20find%20similar%20steps%20in%20the%20documentation%20%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fhh457588.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20here%20%3C%2FA%3E%20.%3C%2FP%3E%0A%20%20%3CP%3E%3CSTRONG%3E%20%3CEM%3E%20Suraj%20Suresh%20Guptha%20%7C%20Program%20Manager%20%7C%20Microsoft%20%3C%2FEM%3E%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%3CP%3EGet%20the%20latest%20System%20Center%20news%20on%20%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2Fpages%2FMicrosoft-System-Center-Support%2F111513322193410%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20%3CSTRONG%3E%20Facebook%20%3C%2FSTRONG%3E%20%3C%2FA%3E%20%3CSTRONG%3E%20%3C%2FSTRONG%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2F%23!%2FMS_SystemCenter%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20%3CSTRONG%3E%20Twitter%20%3C%2FSTRONG%3E%20%3C%2FA%3E%20%3CSTRONG%3E%20%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F82102i1340E85B4A664941%22%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F82103iA27BA64142B6B0A6%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3EMain%20System%20Center%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fsystemcenter%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fsystemcenter%2F%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3EConfiguration%20Manager%20Support%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fconfigurationmgr%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fconfigurationmgr%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Data%20Protection%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fdpm%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fdpm%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Orchestrator%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Forchestrator%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Forchestrator%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Operations%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fmomteam%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fmomteam%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Service%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fservicemanager%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fservicemanager%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Virtual%20Machine%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fscvmm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fscvmm%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3EMicrosoft%20Intune%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fmicrosoftintune%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fmicrosoftintune%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20WSUS%20Support%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fsus%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fsus%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20RMS%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Frms%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Frms%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20App-V%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fappv%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fappv%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20MED-V%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fmedv%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fmedv%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Server%20App-V%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fserverappv%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fserverappv%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3EForefront%20Endpoint%20Protection%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fclientsecurity%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fclientsecurity%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Forefront%20Identity%20Manager%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fb%2Fms-identity-support%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fb%2Fms-identity-support%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Forefront%20TMG%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fisablog%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fisablog%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Forefront%20UAG%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fedgeaccessblog%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fedgeaccessblog%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Application%20Proxy%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fapplicationproxyblog%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fapplicationproxyblog%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Surface%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fsurface%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fsurface%2F%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-350274%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Feb%2023%2C%202015%20We%20are%20pleased%20to%20announce%20that%20System%20Center%202012%20R2%20Operations%20Manager%20(OpsMgr%202012%20R2)%20now%20supports%20SQL%20Server%202014%20Enterprise%2C%20Standard%20(64-bit)%20as%20its%20database.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-350274%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESystem%20Center%20Operations%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 11 2019 10:17 AM
Updated by: