Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I upgraded a SharePoint-integrated SQL 2008 R2 SSRS server to SQL 2012 SSRS over the weekend. The installer said that the installation succeeded, but it appears that the SSRS database upgrade* may have only partially succeeded. When I attempted to access SSRS's settings after the upgrade, I received messages stating that "the report server database is an invalid version" and "The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '147'. The expected version is '162'."

From research I did over the weekend, my understanding is that the database upgrade happens automatically when SSRS comes online. Is there a way to force it to retry the database upgrade without restoring? If not, if I just restore the SQL2008R2 databases to the server, will it redo the upgrade automatically?

(*NOTE: The database upgrade I'm referring to is the SSRS Report Server database, not the database engine. The SSRS database is located on a separate server; SQL's database engine is not installed on the SharePoint server.)

share|improve this question

1 Answer 1

When you create a new SSRS service application and specify the existing SSRS database, it will upgrade at that point in time. The database will not be upgraded just by installing SSRS.

share|improve this answer
    
Is there a way to get it to upgrade the database after it has already been installed? Or will I need to remove SSRS from SharePoint and completely reinstall it? –  Ed Leighton-Dick Oct 17 '12 at 19:44
    
To upgrade after installing SSRS, create the new SSRS 2012 SA and point it at the existing database. It will upgrade the database when the new SA is created. –  Trevor Seward Oct 17 '12 at 20:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.