I am trying to deploy an rdl in VS 2008 and 2 of the 30 reports do not deploy and I get the following error. The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. I looked at some other related questions but they deal with VS 2020 which I don't have. The report server is SQL 2005 and we have both SQL 2005 and SQL 2008 report servers in our domain. Any ideas why 28 of them deploy fine and these 2 get the error above? Thanks. p.s. Using VS 2008 and Win 7.

We lost our SQL 2005 server for a short time and moved all into a SQL 2008 server. When the SQL 2005 server was re-created we moved the reports back to the 2005 server, and thus the errors. Is there anything I can do to get them back on 2005? Thanks.

Hi David, Did you Build those 2 Report on VS 2008.The incompatibility happens when building reports with Visual Studio 2008 and then deploying those report definitions (RDL files) onto SQL 2005 Reporting Services Regards, PS Regards, PS

Hi, Can you Try creating attaching or rather those reports in VS 2005 and deploy the reports, then it should work. Using VS 2008 for sql server 2005 isnt a solution If that to doesnt work So in my case, the options at this point are: 1) upgrade the existing server to SQL Server 2008 (which isn't actually an option at this time due to the constraint of the other application using the same database server), 2) deploy the reports on another server that is already running SQL Server 2008, 3) set up a new server on SQL Server 2008, or 4) go back and recreate all of the reports in Visual Studio 2005 (or 2000). Regards, PS Regards, PS

I think I will have to restore the rdl files from the old SQL 2005 server and then keep them on VS 2005.