May 2, 2017 at 12:33 pm
WSUS in its infinite wisdom applied CU8 to our SQL server. Now we are receiving the following error when attempting to run reports;
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 '163'. The expected version is '164'.
Reporting is on the same instance as SQL, and when I go into the Reporting Services Configuration Manager and restart the service (in order to automatically upgrade the database as per https://technet.microsoft.com/en-us/library/ms403392(v=sql.100).aspx) the database remains at 163 and the error persists. I do not see any way to manually upgrade and am not finding alternatives online.
May 2, 2017 at 1:21 pm
David.Toews 95002 - Tuesday, May 2, 2017 12:33 PMWSUS in its infinite wisdom applied CU8 to our SQL server. Now we are receiving the following error when attempting to run reports;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 '163'. The expected version is '164'.
Reporting is on the same instance as SQL, and when I go into the Reporting Services Configuration Manager and restart the service (in order to automatically upgrade the database as per https://technet.microsoft.com/en-us/library/ms403392(v=sql.100).aspx) the database remains at 163 and the error persists. I do not see any way to manually upgrade and am not finding alternatives online.
The manual upgrade process is in that article you linked to above. The section with the manual upgrade process is toward the end - this link:
Upgrading a Report Server Database
and the section name is: To upgrade the database manually.
You would follow the steps listed their to finish the upgrade manually. Use the existing server, the existing database, etc and click apply.
Sue
May 2, 2017 at 1:38 pm
When I go into RSCM, I connect in to the SSRS database, but it does not provide me with the APPLY option to upgrade the database. Only EXIT is highlighted.
I dug a bit further into the TechNet article, changing the version to 2012 (https://technet.microsoft.com/en-us/library/ms403392(v=sql.110).aspx). At the bottom of this article was a note about the permissions required to upgrade. When I modified the credential in RSCM to an account w/ Sysadmin rights, and restarted the service, it properly upgraded the database. However, I never had previously received the error message mentioned in the article. It would just stop and start the service with no attempt to upgrade. I then changed it back and restarted the service as originally setup.
May 2, 2017 at 2:00 pm
David.Toews 95002 - Tuesday, May 2, 2017 1:38 PMWhen I go into RSCM, I connect in to the SSRS database, but it does not provide me with the APPLY option to upgrade the database. Only EXIT is highlighted.I dug a bit further into the TechNet article, changing the version to 2012 (https://technet.microsoft.com/en-us/library/ms403392(v=sql.110).aspx). At the bottom of this article was a note about the permissions required to upgrade. When I modified the credential in RSCM to an account w/ Sysadmin rights, and restarted the service, it properly upgraded the database. However, I never had previously received the error message mentioned in the article. It would just stop and start the service with no attempt to upgrade. I then changed it back and restarted the service as originally setup.
The same notes on permissions are in both versions of the articles.
The service account is the only account (outside of unattended execution) that I can think of that you would have changed since configuration manager doesn't have it's own account. And that's not the account they are referencing when they say "Setup uses the security token of the user who is running the Setup program". It's whoever is running the setup.
When you connect to Configuration Manager and select Change Database, another window will open for the changes. It has Previous, Next and Cancel buttons. So you weren't on the correct pages, screens for a manual update. You need to select Change Database to perform the manual update.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply