今天我将一个报告服务从sql server 2012迁移到运行sql server 2014的新服务器。 首先,我备份加密密钥并恢复到新服务器,然后按照msdn.microsoft/en-AU/library/ms156421.aspx(例如备份,恢复报告服务器)。在"如何配置报表服务器数据库连接"部分中,我无法通过此步骤,因为它抱怨它不是报表服务器,请看下面的错误:
但是我可以看到我的原始报告/数据位于以下网址中,我可以创建新项目,如数据源:
http:// sydwt-ssql-1 / ReportServer
http:// sydwt-ssql-1 / Reports /
任何人都知道发生了什么事?
以下是版本信息:
- 来自
Microsoft SQL Server 2012(SP1) - 11.0.3412.0(X64) Mar 2 2014 01:25:09 版权所有(c)Microsoft Corporation 企业版(64位)在Windows NT 6.3< X64>上。 (Build 9600:)-
Microsoft SQL Server 2014 - 12.0.2480.0(X64) 2015年1月28日18:53:20 版权所有(c) Microsoft Corporation在桌面6.3上的 企业版(64位)< X64> (Build 9600:)
谢谢,
Albert
解决方案
恢复报告数据库和临时报告数据库 Microsoft SQL Server 2014
检查并确认。
Hi, Today I migrated one reporting service from sql server 2012 to new server which running sql server 2014. Firstly I back up encryption key and restored to new server, then follow the msdn.microsoft/en-AU/library/ms156421.aspx (e.g. backup, restore reportserver). In section "How to Configure the Report Server Database Connection" , I cannot pass this step as it complains it is not a report server, please see error below:
However I can see my original reports/data srouces in below url and I can create new items like data source:
sydwt-ssql-1/ReportServer
sydwt-ssql-1/Reports/
Anyone knows what happened?
Here are the version information:
- From
Microsoft SQL Server 2012 (SP1) - 11.0.3412.0 (X64) Mar 2 2014 01:25:09 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )- To
Microsoft SQL Server 2014 - 12.0.2480.0 (X64) Jan 28 2015 18:53:20 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )Thanks,
Albert
解决方案Have restore Report database and temp report database inMicrosoft SQL Server 2014 ?
check and confirm.
更多推荐
将ReportServer数据库从SQLServer 2012迁移并升级到SQLServer2014
发布评论