When my company made the decision to upgrade our intranet from SharePoint 2007 to SharePoint 2010 version, I was over the moon, but immediately I was told that we wouldn’t be upgrading to SQL Server 2008, it was still fine, because Microsoft states that SharePoint 2010 works with SQL Server 2005 SP2 with cumulative updates. It’s only later when we found out that SQL Server Reporting Services 2005 would not work with SharePoint 2010 in integrated mode.
This is not all, we were lucky enough to get our hands on Visual Studio 2010, but guess what? You can’t develop or even open SSRS 2005 reports in Visual Studio 2010.
Happy coding J