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

Published On: 2008-07-28By:

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

Contact the Author | Contact DCAC

10 responses to “You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server”

  1. Marlin7 says:

    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. Marlin7 says:

    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. TStat says:

    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. mrdenny says:

    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. AmarSale says:

    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. Bandari says:

    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. AmarSale says:

    Hi Bandari,

    Yes. please contact on my email : amarsale@gmail.com.

    Thanks & Regards,
    Amar Sale

  8. AmarSale says:

    Hi BGabriel,

    Yes. please contact on my email : amarsale@gmail.com.

    Thanks & Regards,
    Amar Sale

  9. MrPryor says:

    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

  10. AmarSale says:

    Please visit the downloads section of http://www.ApplyBI.com to get information about the tool for converting 2008 rdl (SSRS Report) to 2005

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP
Share via