SCCM and SCOM using SQL Server 2008

All replies

• 

  

  0

  Sign in to vote

  Supported configurations for ConfigMgr SP1: http://technet.microsoft.com/en-us/library/cc161823.aspx (so yes, SQL 2008 is supported).
  You can co-locate both databases on the same SQL server, but I would not recommend it from a performance point of view.

  • Proposed as answer by Damilola Osude Tuesday, May 11, 2010 10:11 AM

  Monday, May 10, 2010 12:41 PM
• 

  

  0

  Sign in to vote

  If I recall correctly you won't be able to use the same instace of Reporting Services for SCCM since SCOM will use it for its reporting.  SCCM will have to stick with the current web reports.

  ---

  http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

  Monday, May 10, 2010 12:55 PM
• 

  

  0

  Sign in to vote

  word on the street says there is a workaround that. the SCCM requires the default instance of ssrs whils scom can make do with a named instance. check this out below

  http://www.myitforum.com/forums/tm.aspx?high=&m=193894&mpage=1#193905

   

  Monday, May 10, 2010 3:50 PM
• 

  

  0

  Sign in to vote

  To Torsten : according to http://social.technet.microsoft.com/Forums/en-US/configmgrannouncements/thread/729a17a4-eafa-4c98-b5d5-280aaa063f3a I have to use SCCM 2007 SP2 to be working with SQL Server 2008, the supported scenario, first I have to install SQL Server 2005, install the hotfix and upgrade to SQL Server 2008,so I can't use clean installatioin SQL Server 2008 ?

  To Matthew and muppielee : thx, nice info m8 :)

   

   

  ---

  rgds, Krisna

  Monday, May 10, 2010 11:57 PM
• 

  

  0

  Sign in to vote

  to krisna:

  yes you can use a clean install of sql 2008 in as much as you patch it with sp1 or sp2. i am very sure about sp1 but i believe sp2 should not pose any problem either.

  Tuesday, May 11, 2010 5:45 AM
• 

  

  0

  Sign in to vote

  What you mean is SCCM right? Have you try before and there's no problem?

  ---

  rgds, Krisna

  Tuesday, May 11, 2010 5:57 AM
• 

  

  0

  Sign in to vote

  yes. i have deployed sccm 2007 sp2 on sql 2008 with sp1. my os was windows server r2 and i later added feature pack sccm r2, everything went just fine.. :)

  Tuesday, May 11, 2010 6:07 AM
• 

  

  0

  Sign in to vote

  no I mean SCCM 2007 with SP1 deploy on SQL 2008, is it gonna works?

  ---

  rgds, Krisna

  Tuesday, May 11, 2010 9:48 AM
• 

  

  0

  Sign in to vote

  Please re-read the link I already posted. It contains the exact answer to your question.

  Tuesday, May 11, 2010 9:55 AM
• 

  

  0

  Sign in to vote

  hello check this out

  http://www.windows-noob.com/forums/index.php?/topic/487-how-can-i-install-sccm-2007-sp1-in-windows-server-2008

  i have not tried it but someone has so...

  Tuesday, May 11, 2010 10:09 AM
• 

  

  0

  Sign in to vote

  SQL Server Site Database Configurations

  When installing Configuration Manager 2007 SP1, the site database can be installed on either the default instance or a named instance of a supported SQL Server version installation. The instance used to host the site database can also be configured as a SQL Server failover cluster instance in an active/passive cluster, or multiple instance, configuration.

  The following table describes the versions of SQL Server supported to host the Configuration Manager 2007 SP1 site database.

   

  SQL Server Version	Edition	Service Pack	System Architecture
  SQL Server 2005	Standard or Enterprise Edition	SP2 or SP3	x86 or x64
  SQL Server 2008	Standard or Enterprise Edition	No service pack or SP1	x86 or x64

  • Marked as answer by Eric Zhang CHN Friday, May 21, 2010 9:10 AM

  Thursday, May 13, 2010 9:29 AM