CRM 4.0 can be installed on SQL Server 2008.
Refer to http://support.microsoft.com/kb/957053 for more details and specific workarounds that may be needed.
I'm on Linkedin, view my profile at http://www.linkedin.com/profile/view?id=26586935
I'm on Twitter, view my profile at https://twitter.com/fkcrm
I'm on Experts Exchange where I answer questions on Microsoft Dynamics CRM. View my profile at http://www.experts-exchange.com/M_4896612.html
I contribute at the MSDN Dynamics CRM forums at http://social.microsoft.com/Forums/en-US/category/dynamics