System Center Configuration Manager 2007 SP1 and SP2 now support Microsoft SQL Server 2008 R2 as a Configuration Manager 2007 site database. System Center Configuration Manager 2007 R2 now supports Microsoft SQL Server 2008 R2 Reporting Services.
No software updates are required.
Source and more Configuration Manager Support Announcements for June 2010 here.