Microsoft Dynamics CRM 4.0 was released at the end of 2007, so it worked really well (tested more) on Windows 2003, SQL Server 2005, Small Business Server 2003 environments. However, now a days, I see more and more deployments of Microsoft CRM 4.0 on Windows 2008 R2, Exchange Server 2007/2010, SQL Server 2008, and Small Business Server 2008.
I’d recommend reviewing the following Microsoft articles to help:
For folks that want to setup an environment in which both Microsoft Dynamics CRM 4.0 and Microsoft SQL Server 2008 Reporting Services are on the same server (for small deployments or test machine) – you may encounter the following error "Publishing CRM reports failed" during the reports installation section (SBS 2008 environments are OK):
This is due to Microsoft SQL Server 2008 Reporting Services NOT relying on IIS for accessing reports. Microsoft KB Article 957053 provide more info on running Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008 – see Issue 6.
On one of our environments, the article suggestions didn’t work – it also has Exchange 2010 on it (test server). As a work-around, we created an IIS Virtual Directory in the Default Website (Port 80/443) referencing the "ReportServer" path (C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer) which allowed the Microsoft CRM 4.0 installation process to complete successfully:
We tested the reports after the installation and also after applying the latest Update Rollup (UR7) – they ran fine. This approach is unsupported.