You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server

SQL 2008 and SQL 2005 use different RDL namespaces and so they pretty much aren’t compatible.  You can edit SQL 2005 Reports using the SQL 2008 editor, but new reports won’t be able to be deployed to the SQL 2005 report server.

With enough major editing of the SQL 2008 report you can convert it to a SQL 2005 report.

In a future post (you can read this as, as soon as I figure out just what editing needs to be done) I’ll cover what editing needs to be done to the SQL 2008 RDL to make it run within a SQL 2005 Report server.

This is going to come in handy as you can’t have SQL 2005’s UI and SQL 2008’s UI installed on the same machine.

Denny

Share

10 Responses

  1. I went through the trouble and paid the cost of upgrading to VS2008 and installing the BIDS of SQL2008, only to find i can’t upload SSRS2005 reports which i edited in VS/BIDS2008. So i sure would love to see a workaround!

    -On a hunt.

  2. This is the error:
    An error occurred during local report processing. The definition of the report ‘Main Report’ is invalid. 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

  3. I am currently running BIDS for 2008 and Visual Studio for 2005 on the same machine without any issues. I do it here at work as well as my laptop at home. I can write reports for SSRS 2005 or 2008 depending on which server I need to publish to. I personally wouldn’t bother with trying to hack a 2008 report down to work in 2005 as the reason I write in 2008 is to take advantage of 2008’s features. You CAN also simply publish a report written in 2005 to a 2008 report server as it is backwards compatible.

  4. The issue comes when you only have BIDS 2008 and VS 2008 installed and you need to create a report for a SQL 2005 server.

    You can push a SSRS 2005 report to a 2008 server without issue, but going the other way doesn’t work.

  5. Hi mrdenny,

    I have a tool which converts 2008 rdl to 2005 so that they can be deployed on Sql 2005 report server. please free to contact me on :
    amarsale@gmail.com

    Thanks & Regards,
    Amar Sale.

  6. Hi Amar Sale,

    I’ve seen your reply in this mail chain. Can I contact you on your mail amarsale@gmail.com for getting tool. I really need it to convert 2008 rdl files to 2005.

    Thanks in advance.

    Bandari

  7. Currently I am running a 2005 SSRS Website, and 7/9 of my reports are done in 2005, and when I try access the 2 reports in 2008, it prompts me to enter my user name and password again, with this converter, will it solve this issue? I need a solution to get around the authentication of 2008 (with its extra level of authentication) which is not in 2005 SSRS, will this help with this issue, I have looked everywhere and there doesn’t seem to be a solution to this problem.

    Please help on this. i have been looking for 2 months and have been unsuccessful, any solutions or suggestions will be appriciated.

    Please contact me on Grant@bmi.co.za

Leave a Reply to Marlin7Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?