March 29, 2016 at 12:22 pm
Migrating SSRS database from Windows Server 2008 R2, SQL Server 2012 to Windows Server 2012 R2, SQL Server 2014.
Have tried detach and copy of ReportServer and ReportServerTempDB as well as backup and restore. When I try to restore the Encryption Keys I get the error below. I also get a similare message when I try to connect the the Report Server URL.
Microsoft.ReportingServices.WmiProvider.WMIProviderException: 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 '162'. (rsInvalidReportServerDatabase)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, SecureString password)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, SecureString password)
Any help would be greatly appreciated!
March 29, 2016 at 9:32 pm
This was removed by the editor as SPAM
March 30, 2016 at 8:33 am
That is a manual copy and build. Data sources and passwords alone will be a pain. I'm thinking about building out SQL server 2012 doing a migration and then upgrading SQL to 2014. Any issues you see with that process?
March 30, 2016 at 9:44 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply