升级服务器，从sql7.0到sql2000没问题，再到sql2008就出现问题了

公司需要升级服务器，我先试着把空库从7.0升级到2008一遍，升级成功了！接着就把城市数据库加入进去，但是就在sql2000到sql2008升级的过程中，错误的提示描述是：服务“SQLSERVERAGENT”启动请求失败，在网上找了半天没找到相关的原因问题，所以求助一下大家有经验的人士
一下是升级的报告：Overall summary:
  Final result:                  SQL Server 升级失败。若要继续，请调查失败原因，更正问题，使用以下命令行卸载 SQL Server，然后重新运行 SQL Server 安装程序。卸载命令行: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLEngine,Replication
  Exit code (Decimal):           -2068643839
  Exit facility code:            1203
  Exit error code:               1
  Exit message:                  SQL Server 升级失败。若要继续，请调查失败原因，更正问题，使用以下命令行卸载 SQL Server，然后重新运行 SQL Server 安装程序。卸载命令行: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLEngine,Replication
  Start time:                    2013-03-22 13:56:45
  End time:                      2013-03-22 14:06:07
  Requested action:              Upgrade
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130322_135405\sql_engine_core_inst_Cpu32_1.log
  Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22Machine Properties:
  Machine name:                  CZGJ
  Machine processor count:       8
  OS version:                    Windows Server 2003
  OS service pack:               Service Pack 2
  OS region:                     中华人民共和国
  OS language:                   中文(中华人民共和国)
  OS architecture:               x86
  Process architecture:          32 位
  OS clustered:                  否Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 
  Sql Server 2000      MSSQLSERVER                                         SQL Server                               2052                 Enterprise Edition   8.4.2039        否         
  Sql Server 2000      MSSQLSERVER                                         Replication Support                      2052                 Enterprise Edition   8.4.2039        否         
  Sql Server 2000      MSSQLSERVER                                         Debug Symbols                            2052                 Enterprise Edition   8.4.2039        否         
  Sql Server 2000      MSSQLSERVER                                         Performance Counters                     2052                 Enterprise Edition   8.4.2039        否         
  Sql Server 2000                                                          Enterprise Manager                                            Tools                8.00.194        否         
  Sql Server 2000                                                          Profiler                                                      Tools                8.00.194        否         
  Sql Server 2000                                                          Query Analyzer                                                Tools                8.00.194        否         
  Sql Server 2000                                                          DTC Client Support                                            Tools                8.00.194        否         
  Sql Server 2000                                                          Conflict Viewer                                               Tools                8.00.194        否         
  Sql Server 2000                                                          Client Connectivity                                           Tools                8.00.194        否         
  Sql Server 2000                                                          Books Online On Disk                                          Tools                8.00.194        否         
  Sql Server 2000                                                          Debugger Interface                                            Tools                8.00.194        否         
  Sql Server 2000                                                          DTS                                                           Tools                8.00.194        否         Package properties:
  Description:                   SQL Server Database Services 2008
  SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
  ProductName:                   SQL2008
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         D:\工具\SQLFULL_CHS\x86\setup\
  Installation edition:          ENTERPRISE用户输入设置:
  ACTION:                        Upgrade
  AGTDOMAINGROUP:                <空>
  BROWSERSVCSTARTUPTYPE:         Automatic
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130322_135405\ConfigurationFile.ini
  ERRORREPORTING:                False
  FAILOVERCLUSTERROLLOWNERSHIP:  2
  FTSVCACCOUNT:                  <空>
  FTSVCPASSWORD:                 *****
  FTUPGRADEOPTION:               Import
  HELP:                          False
  INDICATEPROGRESS:              False
  INSTANCEID:                    MSSQLSERVER
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
  ISSVCPASSWORD:                 *****
  ISSVCSTARTUPTYPE:              Automatic
  MEDIASOURCE:                   D:\工具\SQLFULL_CHS\
  PID:                           *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  RSCATALOGSERVERINSTANCENAME:   未知
  RSUPGRADEDATABASEACCOUNT:      
  RSUPGRADEPASSWORD:             *****
  SQLDOMAINGROUP:                <空>
  SQMREPORTING:                  False
  X86:                           False  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130322_135405\ConfigurationFile.iniDetailed results:
  Feature:                       数据库引擎服务
  Status:                        失败: 请查看日志了解详细信息
  MSI status:                    已通过
  Configuration status:          失败: 请查看下面的详细信息
  Configuration error code:      0x0A2FBD17@1211@1
  Configuration error description: 服务“SQLSERVERAGENT”启动请求失败。
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130322_135405\Detail.txt  Feature:                       SQL Server 复制
  Status:                        失败: 请查看日志了解详细信息
  MSI status:                    已通过
  Configuration status:          失败: 请查看下面的详细信息
  Configuration error code:      0x0A2FBD17@1211@1
  Configuration error description: 服务“SQLSERVERAGENT”启动请求失败。
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130322_135405\Detail.txt  Feature:                       管理工具 - 完整
  Status:                        已通过
  MSI status:                    已通过
  Configuration status:          已通过  Feature:                       管理工具 - 基本
  Status:                        已通过
  MSI status:                    已通过
  Configuration status:          已通过Rules with failures:Global rules:Scenario specific rules:Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130322_135405\SystemConfigurationCheck_Report.htm
服务器升级

解决方案 »

  1.   

    跨度那么大，不保证没问题，可以尝试先备份出数据库，然后卸载SQLServer，重装SQLServer2008，再还原
      

  2.   

    这个提示：SQLSERVERAGENT”启动请求失败 是个什么意思呢 就差弄懂这个原因了 
      

  3.   

    你看一下WINDOWS EVENT LOG和SQL AGENT LOG看看有什么错误导致AGENT无法启动的。
      

  4.   

    代理启动失败，通常情况下个人认为是因为升级，改变了原有代理所用的账号密码，如果升级完成，仅仅是代理没启动，尝试先重置Windows 的对应SQLServer服务对应的账号密码，然后在SQLServer 配置管理器中把sqlagent的账号密码也重置一次