系统是:Windows Server 2008
数据库是:SQL 2008 是这样的,实例已经安装好的,但是我想添加 Integration Services 服务,因为上一个未解决贴子"使用作业还原失败,没有错误提示"http://topic.csdn.net/u/20110525/09/57946958-bb15-4395-b737-0e2b441d166e.html
使得我想使用IS服务来部署包来执行还原操作.
安装的时间前面都很正常,在安装了一段时间后进度条就停在那不动了"***:正在发布...."
然后提示错误消息.
跟据这个错误,我在网上找的资料:
解决办法:
修改注册表项,去除注册表大小限制,把RegistrySizeLimit的值修改为ffffffff即可:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control
项: RegistrySizeLimit
类型: REG_DWORD
值: 0xffffff (4294967295) 但是, 我在2008系统的注册表里,根本就没有这个项,我创建项也没有用...附下错误日志:
Overall summary:
Final result: 用户已取消
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: 用户已取消
Start time: 2011-05-27 14:27:27
End time: 2011-05-27 15:07:12
Requested action: Install
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110527_142704\OWC11_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: WIN-3Q4MC8U6G4U
Machine processor count: 4
OS version: Windows Server 2008
OS service pack:
OS region: 中华人民共和国
OS language: 中文(中华人民共和国)
OS architecture: x64
Process architecture: 64 位
OS clustered: 否Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 JINHUA MSSQL10.JINHUA 数据库引擎服务 1033 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 JINHUA MSSQL10.JINHUA 数据库引擎服务 2052 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 JINHUA MSSQL10.JINHUA SQL Server 复制 1033 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 JINHUA MSSQL10.JINHUA SQL Server 复制 2052 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 JINHUA MSSQL10.JINHUA 全文搜索 1033 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 管理工具 - 基本 2052 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 管理工具 - 完整 2052 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 客户端工具连接 2052 Enterprise Edition 10.0.1600.22 否 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:\Install File\SQL\x64\setup\
Installation edition: ENTERPRISE用户输入设置:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTSVCACCOUNT: <空>
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASDOMAINGROUP: <空>
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: <空>
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <空>
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110527_142704\ConfigurationFile.ini
ENABLERANU: False
ERRORREPORTING: False
FEATURES: IS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <空>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: D:\Program Files\Microsoft SQL Server\Jinhua\
INSTALLSHAREDWOWDIR: D:\Program Files (x86)\Microsoft SQL Server\Jinhua\
INSTALLSQLDATADIR: <空>
INSTANCEDIR: D:\Program Files\Microsoft SQL Server\Jinhua
INSTANCEID: JINHUA
INSTANCENAME: JINHUA
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: D:\Install File\SQL\
NPENABLED: 0
PID: *****
QUIET: False
QUIETSIMPLE: False
RSINSTALLMODE: FilesOnlyMode
RSSVCACCOUNT: <空>
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <空>
SQLBACKUPDIR: <空>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: <空>
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: <空>
SQLTEMPDBDIR: <空>
SQLTEMPDBLOGDIR: <空>
SQLUSERDBDIR: <空>
SQLUSERDBLOGDIR: <空>
SQMREPORTING: False
TCPENABLED: 0
X86: False Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110527_142704\ConfigurationFile.iniDetailed results:
Feature: Integration Services
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\20110527_142704\SystemConfigurationCheck_Report.htm
数据库是:SQL 2008 是这样的,实例已经安装好的,但是我想添加 Integration Services 服务,因为上一个未解决贴子"使用作业还原失败,没有错误提示"http://topic.csdn.net/u/20110525/09/57946958-bb15-4395-b737-0e2b441d166e.html
使得我想使用IS服务来部署包来执行还原操作.
安装的时间前面都很正常,在安装了一段时间后进度条就停在那不动了"***:正在发布...."
然后提示错误消息.
跟据这个错误,我在网上找的资料:
解决办法:
修改注册表项,去除注册表大小限制,把RegistrySizeLimit的值修改为ffffffff即可:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control
项: RegistrySizeLimit
类型: REG_DWORD
值: 0xffffff (4294967295) 但是, 我在2008系统的注册表里,根本就没有这个项,我创建项也没有用...附下错误日志:
Overall summary:
Final result: 用户已取消
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: 用户已取消
Start time: 2011-05-27 14:27:27
End time: 2011-05-27 15:07:12
Requested action: Install
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110527_142704\OWC11_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: WIN-3Q4MC8U6G4U
Machine processor count: 4
OS version: Windows Server 2008
OS service pack:
OS region: 中华人民共和国
OS language: 中文(中华人民共和国)
OS architecture: x64
Process architecture: 64 位
OS clustered: 否Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 JINHUA MSSQL10.JINHUA 数据库引擎服务 1033 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 JINHUA MSSQL10.JINHUA 数据库引擎服务 2052 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 JINHUA MSSQL10.JINHUA SQL Server 复制 1033 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 JINHUA MSSQL10.JINHUA SQL Server 复制 2052 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 JINHUA MSSQL10.JINHUA 全文搜索 1033 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 管理工具 - 基本 2052 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 管理工具 - 完整 2052 Enterprise Edition 10.0.1600.22 否
Sql Server 2008 客户端工具连接 2052 Enterprise Edition 10.0.1600.22 否 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:\Install File\SQL\x64\setup\
Installation edition: ENTERPRISE用户输入设置:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTSVCACCOUNT: <空>
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASDOMAINGROUP: <空>
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: <空>
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <空>
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110527_142704\ConfigurationFile.ini
ENABLERANU: False
ERRORREPORTING: False
FEATURES: IS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <空>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: D:\Program Files\Microsoft SQL Server\Jinhua\
INSTALLSHAREDWOWDIR: D:\Program Files (x86)\Microsoft SQL Server\Jinhua\
INSTALLSQLDATADIR: <空>
INSTANCEDIR: D:\Program Files\Microsoft SQL Server\Jinhua
INSTANCEID: JINHUA
INSTANCENAME: JINHUA
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: D:\Install File\SQL\
NPENABLED: 0
PID: *****
QUIET: False
QUIETSIMPLE: False
RSINSTALLMODE: FilesOnlyMode
RSSVCACCOUNT: <空>
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <空>
SQLBACKUPDIR: <空>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: <空>
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: <空>
SQLTEMPDBDIR: <空>
SQLTEMPDBLOGDIR: <空>
SQLUSERDBDIR: <空>
SQLUSERDBLOGDIR: <空>
SQMREPORTING: False
TCPENABLED: 0
X86: False Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110527_142704\ConfigurationFile.iniDetailed results:
Feature: Integration Services
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\20110527_142704\SystemConfigurationCheck_Report.htm
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货