SQL Reporting Service 虛擬化時複製機器的小技巧

虛擬化的好處就是機器可以快速的複製，Windows 系統上，用 sysprep 就可以進行更換 newid ，但是 Reporting Service 就會出現錯誤：

The report server cannot decrypt the symmetric key. Most likely, the service account or password has changed. To continue, run rsconfig.exe to update the report server account information.

由於直接複製，所以 SSRS 的 InstallationID 都會一樣，建立 Reporting Service Cluster 時就會相衝，有以下小技巧可以進行，不用重新安裝：

 

STEP 1:

修改 C:\Program Files\Microsoft SQL Server\<SSRS Instance ID>\Reporting Services\ReportServer\rsreportserver.config 中的 InstallationID，換新的 Guid

 

   1:  <Configuration>

   2:      <Dsn>......</Dsn>

   3:      <ConnectionType>Default</ConnectionType>

   4:      <LogonUser></LogonUser>

   5:      <LogonDomain></LogonDomain>

   6:      <LogonCred></LogonCred>

   7:      <InstanceId>MSRS10_50.MSSQL2008</InstanceId>

   8:      <InstallationID>{12345-f89c-4c11-ae78-52117dafbcc2}</InstallationID>

   9:      <Add Key="SecureConnectionLevel" Value="0"/>

  10:      <Add Key="CleanupCycleMinutes" Value="10"/>

  11:      <Add Key="MaxActiveReqForOneUser" Value="20"/>

  12:      <Add Key="DatabaseQueryTimeout" Value="120"/>

  13:      <Add Key="RunningRequestsScavengerCycle" Value="60"/>

  14:      <Add Key="RunningRequestsDbCycle" Value="60"/>

  15:      <Add Key="RunningRequestsAge" Value="30"/>

  16:      <Add Key="MaxScheduleWait" Value="5"/>

  17:      <Add Key="DisplayErrorLink" Value="true"/>

  18:      <Add Key="WebServiceUseFileShareStorage" Value="false"/>

  19:  </Configuration>

 

STEP 2:

Restore Key (SSRS Key 一定要備份出來，否則連線帳密、設定等資訊都沒有辦法再恢復，等於要重新安裝資料庫，非常重要!!)

延伸閱讀

Configuring a VMWare clone for SSRS disaster recovery

http://www.pertell.com/sqlservings/archive/2011/07/configuring-a-vmware-clone-for-ssrs-disaster-recovery/

SQL Server 的版本編號

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
SQL Server 2000 Reporting Services	8.00.0743	C.0.6.43