Upgrade SSRS and SSAS

• ramyours2003

  SSChampion

  Points: 12266

  More actions

  September 4, 2012 at 8:14 am

  #393088

  can any one expalin how to Upgrade SSRS and SSAS from sql 2005 to sql 2008 and what are the prerequisites while upgrading ?

• araman 5322

  Valued Member

  Points: 70

  More actions

  September 6, 2012 at 8:48 am

  #1534526

  For SSRS

  1. Back up encryption keys and ReportServer database.

  2. Restore ReportServer database and apply encryption key to the RS 2008.

  3. Use the Configuration Manager to upgrade the ReportServer database to the RS 2008 format.

  For SSAS,

  Back up and restore ssas dabatases

  Thanks,

  Arun