Dear Sri, I presume you are talking about SQL Server 2005?
Compatibility with service packs can be found on the following page: http://go.microsoft.com/fwlink/?LinkId=17938 Note the following database considerations for Operations Manager 2007: * Operations Manager 2007 does not support a 32-bit Operations Manager Operations database, Reporting Server data warehouse, or Audit Collection database, or SQL Server Reporting Services on a 64-bit operating system. * The use of SQL Server 2005 SP4 is supported for Operations Manager 2007 R2 (See KB2591380<http://go.microsoft.com/fwlink/p/?LinkId=226874> for details.) * The use of SQL Server 2008 R2 is supported for both new installations of Operations Manager 2007 R2 (See KB2425714<http://go.microsoft.com/fwlink/?LinkId=215404> (http://go.microsoft.com/fwlink/?LinkId=215404) for details) and SQL Server 2008 R2 database upgrades (See KB2449679<http://go.microsoft.com/fwlink/?LinkId=215802>(http://go.microsoft.com/fwlink/?LinkId=215802) for details). * The use of SQL Server 2008 SP3 is supported for Operations Manager 2007 R2 with CU5 applied. For more information, see the Supported Software Requirements for Operations Manager 2007 table below. * The use of SQL Server 2008 R2 Service Pack 2 is supported for Operations Manager 2007 R2 with Cumulative Update 7 applied. Note: Installation of reporting mail fail with SQL Server 2008 R2 SP2. If this occurs, follow the procedures in the Support article:Support for System Center Operations Manager 2007 R2 that runs on a SQL Server 2008 R2 database<http://support.microsoft.com/kb/2425714>. * Using a different version of SQL Server for different Operations Manager 2007 roles is not supported. The same version should be used for each role. * SQL collation for all databases must be SQL_Latin1_General_CP1_CI_AS; no other collation configurations are supported. Many regards, David Biot Technical Project Leader [email protected]<mailto:[email protected]> Direct +32 2 801 41 52 [file:///C:\Users\dbtrl53\AppData\Roaming\Microsoft\Signatures\realdolmen_logo.gif]<http://www.realdolmen.com/> This e-mail message and any attachment are intended for the sole use of the recipient(s) named above and may contain information which is confidential and/or protected by intellectual property rights. Any use of the information contained herein (including, but not limited to, total or partial reproduction, communication or distribution in any form) by other persons than the designated recipient(s) is prohibited. If you have received this e-mail in error, please notify the sender either by telephone (+32 2 801 55 55) or by e-mail and delete the material from any computer. Please note that neither RealDolmen nor the sender accept any responsibility for viruses and it is your responsibility to scan or otherwise check this email and any attachments. RealDolmen is nor responsible for the correct and complete transfer of the contents of the sent e-mail, neither for the receipt on due time. [file:///C:\Users\dbtrl53\AppData\Roaming\Microsoft\Signatures\thinkgreen.gif] From: [email protected] [mailto:[email protected]] On Behalf Of Srikanth Thumma Sent: dinsdag 10 september 2013 15:41 To: [email protected] Subject: [msmom] Reg. SQL Server 2005 Service Pack Hi All, Our DB team wanted to apply latest SP4 SQL patch to existing SCOM 2007 DB and DW. Can you please advise if SCOM 2007 R2 CU5 is compatible with the latest SQL service pack . Regards, Sri
