?????????? ???? ?? ???? ??????? ?? ???? ???? ???????? ?? ??? ?????????? ???? ??? ??? ?? ?? ???? ???????? ?? ?? ???? ?? ??? ???? ????

???? ?????? ???? ??????
???? ID: 842425 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

?? ???? ????? ???? ?? ?? ?????????? ???? ?? ???? ??????? ?? ???? ???? ???????? ?? ??? Microsoft SQL Server ?????????? ???? ?? ??? ?? ?? ???? ???????? ?? ?? ???? ?? ??? ???? ????? ?? ???? SQL Server 2005 ?????????? ???? ?? ?????? ?? SQL Server 2005 ?????????? ???? ?? ?????? ?? ????? ???? ???

??? ?? SQL Server 2005 ?????????? ???? ?? ???? ?? ?????? ?? ??? ??? SQL Server 2000 ?????????? ???? ????????? ?? ??????????? ???? ????? ???, ?? ????? Microsoft ?????? ??????? (MSDN) ??? ???? ?? ????:
HTTP://msdn2.Microsoft.com/en-us/library/ms143724.aspx

???? ???????

?? ???? ?? ??? ?????????? ???? ??????? ???? ?? ???????? ?? ???? ???????? ?? ??? ?? ?????? ?? ?? ?? ????? ?????? ?? ???, ???? ?????????? ?????? ?? ????? ???? ????????? ?? ????? ?? ??????? ??? ????? ???? ???? ?? ?? ???? ???????? ?? ??????? ?? ????? ?? ???? ?? ????????? ?? ??????? ?????? ??? ????? ???? ???? ?? ?? ???? ???????? ?? ?? ???? ????? ???, ??? ?????????? ???? Windows ???? ?? ?????? ??? ?????????? ???? ?? ??? ?????????? ???? ??????? ???? ?????? ??? ??? ?? ?? ?????????? ???? ??????? ?? ?????? ?????????? ???? ?? ???????? ?? ????? ???????? ?? ???, ?? ??????? ?? ???: ?????? ???? ?? ???? ???

SQL Server 2000 ?????????? ????



???? ???? ???????? ?? SQL Server 2000 ?????????? ???? ?? ???? ??????? ?? ?? ???? ?? ??? ?? ?????????? ???? ?? ??????? ?? ????? ???? ?? ???, ????? ????? ?? ???? ????:
  1. ????? ???????? ?? ?????????? ???? ??????? ?? ?????????? ???? ??????? ??????? ?? ????? ????

    ???:???????? ??? ??, ?????????? ???? ??????? ?? ??? ??ReportServer, ?? ?????????? ???? ??????? ??????? ?? ??? ??ReportServerTempDB.
  2. ?? ?? ????? ??? 1 ??? ?????? ???????? ?? SQL ????? ?? ??????? ??????? ?? ??????? ???????????? ?????
  3. ?????????? ???? ??????? ??? 2 ??? ???????????? ???? ?? ??? ????? ???? ?? ???, ????? ???? ????? ????? ????????? ?? ???????? ?? ?? ??????? ????? ?? ??? ??? ???????? ???? ??? ??:

    RSConfig - c -s????? ???-d?????????? ???? ??????? ???-??? Sql|Windows -u?????????? ???-p?????????? ?? ???????

    ???:Rsconfig.exe ????-?????? ?????? ?? ???? ??? ???? ??????? ?? ??? ????? ????????? ?? ????? ???? ?????:

    RSConfig /?
???? ?? ??? ?????????? ???? Windows ???? ?? ?????? ??? ?????????? ???? ?? ??? ?????????? ???? ?? ??????? ?? ?? ???????? ?? ????? ???????? ?? ???, ???? ?????? ???? ????? ??????????? ????? ????? ???????? ??? ?? ?? ?????? ???????? ?? ??????????? ???????? ?? ???????????? ???? ?? ?? ?? ?????????? ???? ??????? ????? ???????? ?? ?????? ???????? ?? ??? ?? ???? ???? ??? ???? ?? ???, ????? ????? ?? ???? ????::
  1. ????? ???????? ?? ????? ????????? ??????????? ????? Rskeymgmt.exe ????-?????? ?????? ?? ????? ????? ??? ???? ?? ???, ????? ????????? ?? ????? ???? ?????:

    RSKeyMgmt.exe -? -f????? ??? ?? ??-p????? ???????

    ???:Rskeymgmt.exe ????-?????? ?????? ?? ???? ??? ???? ??????? ?? ??? ????? ????????? ?? ????? ???? ?????:

    RSKeyMgmt /?
  2. ?????? ???????? ?? ????? ????? ?? ???? ????:
    1. ?????????? ???? ??????? ?????
    2. Windows ????? ??? ??????? ???? ?? ??? ?????
    3. Microsoft ??????? ????? ?????? (IIS) ??? ?????
  3. ?????????? ???? ??????? ?? ?? ???? ?????????? ???? ??????? ??????? ????? ???????? ?? SQL ????? ?? ???? ?????? ?? ??? ?????? ???????? ???

    ???:???????? ??? ??, ?????????? ???? ??????? ?? ??? ??ReportServer, ?? ?????????? ???? ??????? ??????? ?? ??? ??ReportServerTempDB.

    ??????? ?? SQL Server ??? ??? ???????? ?? ??? ?? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
    314546??????? ?? SQL Server ??? ??? ???????? ?? ??? ?? ???? ?? ??? ???? ????
  4. ?????? ???????? ?? ????? ????? ?? ???? ????:
    1. Windows ????? ??? ??????? ???? ??????? ?????
    2. IIS ??????? ?????
    3. ?????????? ???? ??????? ??????????? ???? ?? ??? ??? 3 ??? ?????? ???????? ?? ????? ???? ?? ??? ??????? ????? ??????? ?? ???????? ???? ?? ??? Rsconfig.exe ????-?????? ?????? ?? ????? ????? ??? ???? ?? ???, ????? ????????? ?? ????? ???? ?????:

      RSConfig - c -s????? ???-d?????????? ???? ??????? ???-??? Sql|Windows -u?????????? ???-p?????????? ?? ???????

      ???:Rsconfig.exe ????-?????? ?????? ?? ???? ??? ???? ??????? ?? ??? ????? ????????? ?? ????? ???? ?????:

      RSConfig /?
    4. ?? ????? ??? 1 ??? ????????? ??????????? ????? ?? ???? ???? ?? ??? Rskeymgmt.exe ????-?????? ?????? ?? ????? ????? ??? ???? ?? ???, ????? ????????? ?? ????? ???? ?????

      ???:????? ??? ?? ??????? ?? ??? ?? ?? ??????? ?????????????? ?? ?? ???? ??? 1 ??? ????? ???? ??):

      RSKeyMgmt - ??? -f????? ??? ?? ??-p????? ???????
???:?? ???? ??? ?????? ??? ???? ???? ??????? ??????? ????? ???????????? ?? ????? ?? ???????? ?? ??? ???? ???? ??? ?????? ?? ?? ?? ?????? ?????? ?? ??? ?????? ??? ?? ???? ??????? ??? ???? ?? ??? ??? ???? ???????? ?? ???? ????? ?? ????? ?????? ?? ???????? ????? ?? ?????? ???????? ?? ??? ????? ??? ??? farm ???? ??????? ??????? ???? ??????

?? ?????? ?? ?? ???? ?? ??? ???????? ??? ?? ????????????? ?? ????? ?????? ??????? > -1???? ???? ?? ?? ??? ????? ????? ?? ???? ????? ???????? ??? ?? ????????????? ?? ????? ?????? ??????? > -1???? ?? ???? ???????? ??? ???? ??? ??? ??? farm ??, ?? ??? ???? ????? ??? ??? farm presumably ??? ?? ??? ?? ??? ??? ?? ????? ???? ?????? ???

SQL ????? 2005 ?????????? ????

???:SQL ????? 2005 ?????????? ???? ??????? ?? ????? ?? ??? ?? ReportServer ???? ?????

???? ???? ???????? ?? SQL Server 2005 ?????????? ???? ?? ???? ??????? ?? ?? ???? ?? ??? ?? ?????????? ???? ?? ??????? ?? ????? ???? ?? ???, ????? ????? ?? ???? ????:
????? ?? ????? ?? ????????
  1. SQL ????? Studio ??????? ?? ?????, ?? SQL Server 2005 ?? ?????? ?? ??? ??? ?? ?????? ?????
  2. ??? ?? ReportServer ???????, ReportServerTempDB ???????, ?? ??? ?? ??????? ?? ?? ???? ??????? ?? ?????? ????? ?? ?????? ?? ?????

    ?? ????? ??? ?? ???? ??????? ?? ???????????? ???? ???? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
    HTTP://msdn2.Microsoft.com/en-us/library/ms143724.aspx
  3. Back up the encryption key by using the Reporting Services configuration Manager.

    For more information about how to back up the encryption key, visit the following MSDN Web site:
    http://msdn2.microsoft.com/en-us/library/ms157275.aspx
  4. Copy the backup database files and the backup encryption key file to the destination server.
Operations on the destination server
  1. Stop Internet Information Services (IIS) service by running theiisreset /stop????? ????????? ?? ?????

    For more information about how to start and stop IIS, visit the following Microsoft Web site:
    http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/95826e7a-bac4-4e1f-bcb6-c52d49c9d7f4.mspx?mfr=true
  2. Open the Reporting Services Configuration Manager, and then connect to the instance of SQL Server 2005 Reporting Services.
  3. To stop reporting services windows service, clickServer Status?? ????-????? ????, ?? ???? ???STOP:????? ????Report Server Statuspage . ???STOP:is unavailable, the service has already been stopped,
  4. Open SQL Server Management Studio, and then connect to the instance of SQL Server 2005.
  5. Back up the ReportServer database and the ReportServerTempDB database if they exist.
  6. Detach the ReportServer database and the ReportServerTempDB database if they exist.
  7. Restore the backup databases from the source server.
  8. In the Reporting Services Configuration Manager, make sure that the configurations in the following pages are identical to those in the source server:
    • Configurations inReport Server Virtual Directory
    • Configurations inReport Manager Virtual Directory
    • Type of service account configuration inWindows Service Identity
    • TheReport Serverconfiguration and theReport Managerconfiguration inWeb Service Identity
  9. To start reporting services windows service, clickServer Statusin the Reporting Services Configuration Manager, and then click???????????? ????????? ?? ?????? ?????????????
  10. ????? IIS ???? ??????? ????iisreset /start????? ????????? ?? ?????
  11. ??????????? ????? ?? ????? ?? ????? ?? ???????? ??? SQL Server 2005 ?????????? ???? ??? ?? SQL Server 2005 ??????????? ??????? ?? ??? ????? ??, ?? ?? ?? ???? ??? ?? ????? ???? ??? ?????????? ???? ??????????? ???????? ??? ????, ?? ?? ?????? ???? ???rskeymgmt?? ???? ???? ?? ??? ???????

    SQL ????? 2005 ??????????? ??????? ???????

    1. ?????????? ???? ??????????? ?????? ???, ????? ?????? ???????.
    2. ?? SQL Server 2005 ?? ???? ?????????? ??????????? ????? ?? ?????? ???? ????? ?? ?????? ????? ?? ??? ??? ?? ?? ????? ??? ?? ?? ?????
    3. ?????????? ???? ??????????? ?????? ???, ????? ??????????????? ?????????? ????-????? ????, ?? ???? ??????????????? ???????????????????? ???????????
    4. ???????????????? ????? ???????????? ???, ?????? ??????? ??????????? ????? ????? ?? ????? ??, ?? ????? ??????????? ?? ?????? ????? ?? ??? ????? ????? ?? ????? ?? ?????, ?? ???? ???OK.

    SQL ????? 2005 ??????? ?? ???? ???????



    ???:?? approach SQL Server 2005 ??????????? ??????? ?????? ?? ??? ?? ???? ?????
    1. ????? ????,???????????? ????,???????????:cmd?? ????-????? ????, ?? ???? ???OK????? ????????? ????? ????? ???
    2. ??????????? ????? ?? ????? ?? ???? ????? SQL ????? 2005 ?????? ????? ?? ??????? ?? ??????? ?? ?????? ?? ?????? ??, ?? ????? ???? ????? ????????? ????? ????

      ??????? ???????
      ??????:rskeymgmt -l, ?? ???? ??? ?????ENTER

      ???????? ???????
      ??????:rskeymgmt -l -iInstName,?? ???? ??? ?????ENTER

      ?? ?? ??????????? ????? ???????? ???????? ????? ?? ????? ?? ?? ??, ?? ???? ?????? ????? ?? ??? ??????????? ????? ???????? ?? ?????? ??????????? ??:
      ComputerName\InstNameEncryptionKeyID

      ???:ComputerName?????? ????? ?? ??? ???InstNameSQL ????? 2005 ?? ?????? ?? ??? ?? ??? ??????????? ??????? ?? ?????? ????? ?? ???EncryptionKeyID??????????? ????? ?? ID ?? ??? ??????????? ???
    3. ????? ?? ????? ?? ??????????? ????? ?? ?????? SQL Server 2005 ?? ???????? ?? ??????? ?? ??????? ?? ?????? ?? ?????? ??, ?? ????? ???? ????? ????????? ????? ????

      ??????? ???????
      ??????:rskeymgmt - rSourceEncryptionKeyID, ?? ???? ??? ?????ENTER

      ???????? ???????
      ??????:rskeymgmt -iInstName-rSourceEncryptionKeyID,?? ???? ??? ?????ENTER

      ???:SourceEncryptionKeyID??? 2 ??? ??????? ?? ?? ?? ????? ????? ?? ??????????? ????? ?? ID ?? ??? ??????????? ???
    4. ??? 2 ?? ???????? ?? ????? ?? ???? ??????????? ????? ?? ?????? ????? ?? ?? ????????
  12. ????? ??????????? ????? ????? ?? ????? ?? ???????????? ????? ??? ???? ?? ???, ????? ????? ?? ???? ????::
    1. ?????????? ???? ??????????? ?????? ???, ????? ??????????????? ?????????? ????-????? ????, ?? ???? ??????????????? ???????????????????? ???????????
    2. ???????????????? ????? ???????????? ???, ?????? ??????? ??????????? ????? ????? ?? ????? ??, ?? ????? ??????????? ?? ?????? ????? ?? ??? ????? ????? ?? ????? ?? ?????, ?? ???? ???OK.
  13. ????????? ???? ?? asp.NET ???? ???? ?? ??? ??? ?? ?? ?????????? ???? Rsreportserver.config ????? ?? ??? ??? ??? ???? ?? ???, ????? ????? ?? ???? ????::
    1. ?????????? ???? ??????????? ?????? ???, ????? ??????? ???? ?? ?????. ?????ASP.NET ???? ???????????.
    2. ?????SQLInstall: \Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer ???????? Rsreportserver.config ????? ?? ????-????? ????, ?? ???? ??? ????? ???????.

      ???:SQLInstall?????? ???? SQL Server 2005 ??????? ?? ?? ??? ??????????? ???MSSQL.XSQL ????? 2005 ??????? ?????? ?? ?????? ????? ?? ?? ??? ?? ?? ?????? ?? ?????? ID ?? ??? ??????????? ??? ?????? ID ?? ??????? ???? ?? ??? ????? ????????? ???????????????? ???? ??????????? ???????, ?? ???? ??? ????????????? ID???????.
    3. ?????Rsreportserver ???????? ????? ???, ????? ?????????????? ?? ????? ????..
    4. ??? asp.NET ???? ???? ???????? ???? ??, ??? ??????? ????????? ???? ?? asp.NET ???? ???? ??????, ??????? ?? ?????????????????.
    5. ????? ????,OK??? ???? ?? ???Rsreportserver ???????? ??? ????? ??..
  14. ??? ??????? ??? ?????, ?? ?????? ????? ?? ??????? ?? ??????
?? ?? ?????? ????? ?? ??????? ????? ???????? ?? ????? ???? ???, ??? ?? SQL Server ??????? Studio ??? ??????? ?? ????? ?? ??? ??????? ???????? ?? ???? ???? ?? ??? ??? ??? ??? ?? ?????? ????? ???????? ??? ???? ?????? ???

??????

?????????? ???? ?? ???? ??????? ?? ??????????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:
HTTP://msdn2.Microsoft.com/en-us/library/aa972237.aspx
??????? ?? ???? SQL Server ??? ??? ???????? ?? ??? ?? ???? ?? ?????? ?? ???????? ?? ?? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
240872??????? ?? ???? SQL ????? ?? ??? ????? ?? ??? ?? ???? ?? ?????? ?? ???????? ?? ?? ???? ?? ??? ???? ????

???

???? ID: 842425 - ????? ???????: 05 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2000 Reporting Services
  • Microsoft SQL Server 2005 Reporting Services
??????: 
kbsql2005rs kbexpertiseadvanced kbinfo kbreport kbserver kbdatabase kbsettings kbconsole kbhowto kbmt KB842425 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:842425

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com