SSRS报告服务给出一个错误，找到的版本是'163‘。预期版本为'176‘

Question

当我检查日志时，它显示以下错误。我已经更新了2012年到2016年的数据库。

Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: 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.
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.
    An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database
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 '176'. (rsInvalidReportServerDatabase)

Answer 1

这是因为你连接的数据库是2012年，如果我们假设你像你说的那样从2012年升级到2016年……尝试备份数据库并将其恢复到较新的版本。如果接受，则重新安装报表服务器...

Answer 2

不确定这是否与您的情况相同，但在尝试将我的SSRS ReportServer数据库从SharePoint 2013迁移到SharePoint 2016时，我遇到了相同的错误(尝试使用SP2016 -SPRSServiceApplication命令小程序在SP2016场中创建报告服务时失败)。

这个问题是因为我的数据库服务器还安装了SharePoint服务- SharePoint组件，而不仅仅是安装了数据库引擎。删除此组件后，我可以创建服务应用程序并升级数据库，而不会出现任何问题。

Reporting服务- SharePoint组件只能安装在SharePoint应用程序服务器上，用于SharePoint产品的Reporting服务插件应该安装在应用程序服务器和web前端上。