Wednesday, May 26, 2010 10:45 PM
R2 for SQL 2008 Express edition was recently released. The maximum database size jumped from 4GB to 10GB.
I don't see the answer to the specific question here of whether SCE 2010 is supported on SQL 2008 Express Edition R2 with advanced services. The release notes show SQL 2008 is supported, but I need the R2 version and want to be sure.
Thursday, May 27, 2010 7:59 AMModerator
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:
Given this situation, SQL 2008 R2 should support SCE2010. Hope it helps.
Vivian Xing - MSFT
Thursday, May 27, 2010 6:22 PM
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
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.
This posting is provided "AS IS" with no warranties, and confers no rights.
- Marked As Answer by Vivian XingModerator Friday, June 04, 2010 7:55 AM
Monday, May 09, 2011 9:16 PM
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
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.