Migrating SSRS 2005 to SSRS 2008 RRS feed

  • Question

  • Hi,
    I know there are lot of positve points for Migrating SSRS 2005 to SSRS 2008.Is there any pitfalls for migrating the same?
    Wednesday, September 23, 2009 2:23 AM


  • Hi Kushboo,


    As you know, there have a lot of positive points for migrating SQL Server Reporting Services 2005 to SQL Server Reporting Services 2008. For more information about this topic, please see “What's New (Reporting Services)”.


    For your question “Is there any changes between SQL Server Reporting Services 2005 and SQL Server Reporting Services 2008”, the answer is YES.

    For example:

    Migrating to SQL Server 2008 offers significant benefits in deployment and processing, but you should be aware that not all functionality from previous versions is available in SQL Server 2008. Specifically, if you are using a third-party single sign-on technology solution or custom features that integrate with Reporting Services through Internet Information Services (IIS), your current solution will not work on a new report server installation. You will have to redesign your solution for a SQL Server 2008 report server.

    The SQL Server Reporting Services does not allow anonymous access, if we have implement a custom application for SQL Server Reporting Services 2005 that using anonymous authentication, the custom application won’t work for SQL Server Reporting Services 2008.


    Before you migrate, evaluate the new software and test reports and other items to ensure your business requirements are met. The following links provide information to help you determine a migration strategy:


    Please feel free to ask, if you have any more questions.



    Jin Chen

    Jin Chen - MSFT
    • Marked as answer by Revathy Menon Friday, September 25, 2009 2:56 PM
    Thursday, September 24, 2009 3:50 AM