I'm developing Reporting services on VS2005 and have to connect to SQL Server 2008. The following Error occurs: "This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later."
I found on the net a patch for it, but it doesn't work (link to patch)
"The upgrade patch cannot be installed by the Windows Installer Service because the program to be upgraded is missing, or the upgrade patch may update a different version of the program."
what else can I do ? :(
Reporting Services are very different between 2005 and 2008. You'll need to use the 2008 tools to develop reports for 2008. You can just use the Business Intelligence Studio which comes with SQL Server 2008 - this uses Visual Studio 2008 anyway. I'm fairly sure the patch you've got won't add support for SQL Server Reporting Services 2008.
If you need to use the Reports from Visual Studio 2005, you'll need to use SQL Server Reporting Services 2005 (it is actually possible to install this alongside SQL Server 2008). I've had a separate problem which means my reports won't work on SSRS 2008, but I've switched to SQL Server 2008. I'm successfully running SSRS2005 connecting to a SQL2008 Database.