Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
Is SQL Express 2008 R2 supported with SCE2010?

Answered Is SQL Express 2008 R2 supported with SCE2010?

All Replies

  • Thursday, May 27, 2010 7:59 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    I did not test it locally. However, here is a blog I found. According to the description, SCE 2010 RTM install with SQl 2008 R2 on Hyper-V:

    http://blog.thefullcircle.com/2010/05/13/sce-2010-rtm-install-sql2008r2-hyper-v/

    Given this situation, SQL 2008 R2 should support SCE2010. Hope it helps.

    Vivian Xing - MSFT
     
  • Thursday, May 27, 2010 6:22 PM
     
     
    Sign In to Vote
    0

    I went to the link provided above.  It appears to be nothing more than the start of a blog that doesn't contain any information.  There is one sentence followed by a link to Microsoft's SQL 2008 product version comparisons. 

    IMO, sorry, that doesn't help. 

     
  • Friday, May 28, 2010 3:52 AM
     
     Answered
    Sign In to Vote
    0

    We haven't yet tested SQL Server 2008 R2 with Essentials 2010. If you are wanting to use a free edition of SQL Server with Essentials we recommend having Essentials install the version included as part of the install.

    Irrespective of the version/edition of SQL Server used, Essentials will only keep up to 37 days of data. Without a change to Essentials the larger supported database size in SQL Server 2008 R2 is unlikely to be used by Essentials.

    Thanks

    Richard

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
  • Monday, May 09, 2011 9:16 PM
     
     
    Sign In to Vote
    0

    you're right I really should have finished that post, but to answer the question - a no and a yes..

    SQL 2008 R2 does work with SCE2010 although I don't know about Express edition... We have our SystemCenterEssentials dB on another host that happens to be a SQL Enterprise Edition box but as said it is holding the SCE dB (amongst others)

     

    Reuben Cook CCNA, CCNP, MCSE, MCP+I, TS: Mobile, CfgMgr, OpsMgr, Virtualisation, SBS2008
     
  • Sunday, June 05, 2011 5:56 AM
     
     
    Sign In to Vote
    0

    Hi,

    Yes it does work, but it has to be the advanced version with management tools and reporting. Here are couple of pointers though.

    It has to be installed on the same machine entity as the SCE because SCE requires the tools and reporting and also WSUS DB to be on the same instance.

    I have been running and torturing the setup for 2 weeks, haven't run into any issues yet.

     

    Hope this helps.

    CP