1.项目背景
由于历史原因，公司部分系统的Report是基于SQL Server Report Service搭建的，且Reporting Services 和Report Server DataBase是部署在不同的DB上的。因报表数据库所在机器过保，需要将Report Server数据库和ReportServerTempDB数据库迁移至新的Server上。但因项目老旧，研发和运维人员更迭，相关文档不完善，所以，这次迁移过程中，我们还是遇到了一个不小的坑。
迁移要求，如下图所示：
但是很不幸，迁移后，report service 报错。
2.报错信息
service 错误信息如下：
报表服务器数据库的版本格式无效，或无法读取。已找到的版本为"147"，而所需的版本为"C.0.8.54"。若要继续操作，请更新报表服务器数据库的版本并验证其访问权限。 (rsInvalidReportServerDatabase) (rsRPCError) 获取联机帮助
查看report 服务的log，文件 ReportServerService__12_04_2018_18_56_15.log.txt,
完整的信息如下
<Header> <Product>Microsoft SQL Server Reporting Services 版本 9.00.5000.00</Product> <Locale>zh-CN</Locale> <TimeZone>中国标准时间</TimeZone> <Path>Z:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServerService__12_4_2021_18_56_15.log</Path> <SystemName>weixinqqyijiaqin113</SystemName> <OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName> <OSVersion>6.1.7601.65536</OSVersion></Header>ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing MaxActiveReqForOneUser to '300' requests(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.ReportingServicesService!library!4!2018/12/4-18:56:15:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.ReportingServicesService!resourceutilities!4!2018/12/4-18:56:16:: i INFO: Reporting Services starting SKU: EnterpriseReportingServicesService!resourceutilities!4!2018/12/4-18:56:16:: i INFO: Evaluation copy: 0 days leftReportingServicesService!library!9!2018/12/4-18:56:16:: i INFO: Catalog SQL Server Edition = EnterpriseReportingServicesService!library!9!2018/12/4-18:56:16:: i INFO: Current DB Version 147, Instance Version C.0.8.54.ReportingServicesService!library!9!2018/12/4-18:56:16:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: 报表服务器数据库的版本格式无效，或无法读取。已找到的版本为"147"，而所需的版本为"C.0.8.54"。若要继续操作，请更新报表服务器数据库的版本并验证其访问权限。, ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: 报表服务器数据库的版本格式无效，或无法读取。已找到的版本为"147"，而所需的版本为"C.0.8.54"。若要继续操作，请更新报表服务器数据库的版本并验证其访问权限。ReportingServicesService!library!9!2018/12/4-18:56:16:: e ERROR: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: 报表服务器数据库的版本格式无效，或无法读取。已找到的版本为"147"，而所需的版本为"C.0.8.54"。若要继续操作，请更新报表服务器数据库的版本并验证其访问权限。 在 Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion() 在 Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() 在 Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()ReportingServicesService!library!9!2018/12/4-18:56:16:: e ERROR: Attempting to start service again...
3.错误分析
3.1 简单分析尝试
查看迁移前后两台机器的SQL实例，其版本一致,确实一致，如下:
Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64)
按照提示及大众意见，点击升级数据库也不行
提示数据库的版本验证不通过。
3.2 从版本入手，重点分析版本
错误提示版本不对，那我们找下Report server 和 Report server database的版本信息。下表列出了截至目前（2015/04/29）发布的报表服务器和报表服务器数据库的版本号：
Release | Report server | Report server database |
|---|---|---|
SQL Server 2008 R2 | 10.50.nnnn.nn | n/a |
SQL Server 2008 Service Pack 1 (SP1) | 10.0.2531.00 | C.0.9.45 |
SQL Server 2008 | 10.0.1600.00 | C.0.9.45 |
SQL Server 2005 Reporting Services Service Pack 3 (SP3) | 9.0.4035.00 | C.0.8.54 |
SQL Server 2005 Reporting Services Service Pack 2 (SP2) | 9.0.3042.00 | C.0.8.54 |
SQL Server 2005 Express with Advanced Services | 9.0.3042.00 | C.0.8.45 |
SQL Server 2005 Reporting Services Service Pack 1 (SP1) | 9.0.2049.00 | C.0.8.43 |
SQL Server 2005 Reporting Services | 9.0.1399.01 | C.0.8.40 |
SQL Server 2000 Reporting Services Service Pack 2 (SP2) | 8.00.1038 | C.0.6.54 |
SQL Server 2000 Reporting Services Service Pack 1 (SP1) | 8.00.0878 | C.0.6.51...... 原文转载：http://www.shaoqun.com/a/827751.html 跨境电商：https://www.ikjzd.com/ blibli：https://www.ikjzd.com/w/1676 飞书互动：https://www.ikjzd.com/w/1319.html 好东东网：https://www.ikjzd.com/w/1238 1.项目背景由于历史原因，公司部分系统的Report是基于SQLServerReportService搭建的，且ReportingServices和ReportServerDataBase是部署在不同的DB上的。因报表数据库所在机器过保，需要将ReportServer数据库和ReportServerTempDB数据库迁移至新的Server上。但因项目老旧，研发和运维人员更迭，相关文档不完善，所以， c-tick认证：https://www.ikjzd.com/w/2074 丽江候鸟木语在哪里，怎么走？：http://www.30bags.com/a/455061.html 丽江候鸟木语门票2021年6月价格：http://www.30bags.com/a/455062.html 复工在即 亚马逊退换货政策巨变！卖家忐忑不安：https://www.ikjzd.com/articles/116423 卖家注意，亚马逊将删除声称能够阻止冠状病毒的产品清单！：https://www.ikjzd.com/articles/116424 搜索算法测试新功能，这类卖家有福了!：https://www.ikjzd.com/articles/116425 口述：婆婆为了让我生孩子补到流鼻血：http://lady.shaoqun.com/a/117402.html 口述实录：用谎言堆砌的婚姻 还能走多久？：http://lady.shaoqun.com/a/253157.html 口述和异性同桌之间暧昧的事 我喜欢上他是青春的悸动：http://lady.shaoqun.com/m/a/270067.html 村长把小娥压在玉米地 又粗又大的机巴好爽：http://lady.shaoqun.com/a/247046.html 小舅子媳妇用胸撩拨 与我激情缠绵(2/2)：http://lady.shaoqun.com/m/a/49359.html 深圳沙鱼涌海滩收费吗：http://www.30bags.com/a/455069.html 
订阅：
博文评论 (Atom)
跨境电商资讯：外贸宣传平台有哪些（出口的现在很多做外贸的人都非常关注 外贸企业怎么推广 ，而现在推广的途径和平台有很多，企业如果都做，成本和时间精力是一个问题，而且并不是所有的推广渠道都是有用的。今天云程网络就来为大家盘点几个有效的外贸推广渠道。 一、海外社交媒体营销 Facebook，领英等海外社交媒体营销在近几年得... 
|
没有评论:
发表评论