Report Server Encryption Key deletion giving error

Question

Hi Team,

After I restored the ReportServer Database on new hardware, I am getting following error while deletion of Encryption key.

---

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.DeleteEncryptedInformation()
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()

---

All credentials are working fine and no issues observed on connection settings.

Can you please check and suggest any method to delete the encryption keys.

Many thanks.

Best Regards,

Swapnil Kandekar

Answer 1

Have you done all steps documented here? https://learn.microsoft.com/en-us/sql/reporting-services/report-server/moving-the-report-server-databases-to-another-computer-ssrs-native-mode?view=sql-server-ver15

As last step you have to restore the encryption key from the old server.

Answer 2

Hi Olaf,
Many thanks for your help.
I did these steps again. so Encryption keys are correctly restored. But after all steps completed, I got new error with Configuration Report URL. http://<servername:80>/Reports

---

The service is not available.

Error in the report server database. This could be due to a connection failure, a timeout, or a lack of space in the database.

---

BR,
Swapnil

Answer 3

Hi @Kandekar, Swapnil ，

You may try below steps for a try.

1.Restart SSRS to see if you could access the url.

2.Ensure that the SSRS instance’s service account (can be found in SQL Server Configuration Manager) has db_owner access to the respective ReportServer and ReportServerTempDB databases.

If these steps don't work, please check the error log for more details.

In SQL Server Reporting Services 2016 or earlier: C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles

In SQL Server Reporting Services 2017 later: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles
Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Answer 4

Hi Zoe,
Many thanks for your help.

Unfortunately option 1 or 2 didn't help to resolve the issue.

Here is the log extract -

2020-12-03 17:07:18.3179|INFO|7|Could not find ProductInfo table. Will do first-time upgrade.| RequestID = s_d5322406-39b4-4431-8406-4f25a82e1860
2020-12-03 17:07:18.3179|INFO|6|Upgrading ReportServer database to version 14.0.600.1453 hash 897C815D22224A83AAFE1E1D9283CE6E1D327CB3DBCCC1551CBC82F713800FF7| RequestID = s_d5322406-39b4-4431-8406-4f25a82e1860

2020-12-03 17:07:18.3648|ERROR|6|Aborting SQL batch script! Error executing SQL batch script at entry

CREATE FUNCTION [dbo].[ExtendedCatalog]

2020-12-03 17:00:04.3657|FATAL|7|Database upgrade failed!! The database may now be in an inconsistent state.| RequestID = s_0fe2fd2e-e634-45e5-bb02-91df5b4de083 System.Data.SqlClient.SqlException (0x80131904): Cannot convert to text/ntext or collate to '??&.???...' because these legacy LOB types do not support the Unicode supplementary characters whose codepoints are U+10000 or greater. Use types varchar(max), nvarchar(max), or a collation which does not have the _SC flag.
Cannot convert to text/ntext or collate to '??&.???...' because these legacy LOB types do not support the Unicode supplementary characters whose codepoints are U+10000 or greater. Use types varchar(max), nvarchar(max), or a collation which does not have the _SC flag.

Please suggest.

BR,
Swapnil