Sql server安装遇到的问题

今天安装Sql server2000,遇到三个问题,在网上搜解决的办法,试过之后,问题解决O(∩_∩)O~。在这里汇总一下,方便查阅。

一、以前的某个程序安装已在安装计 算机上创建挂起的文件操作。运行安装程序之前必须重新启动计算机 !

很多人在安装时遇到挂起操作提 示时,进行不下去了,只能按确定退出安装。重启计算机后依然没用,还是有挂起提示。即使在HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager中找到PendingFileRenameOperations项目,并删除它。这样重新安装时还是会有挂起提示,实在郁闷!正确的做法应 该是:
    在准备重新安装前:1.添加/删除程序中彻底删除sql server。 2.将没有删除的sql server目录也删除掉。 3.删除注册表中跟sql server相关的键。然后开始运行安装程序.在计算机提示:“以 前的某个程序安装已在安装计算机上创建挂起的文件操作。运行安装程序之前必须重新启动计算机!”后, 点击确定(注意千万不要退出安装程序,不然你就前功尽弃了),然后按Alt+Tab键切换打开注册表编辑器HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager中找到PendingFileRenameOperations项目.顺便说一下,可 能有的人说找不到PendingFileRenameOperations项,确实,以 前我也找不到,只看到有个什么   Power选项.其实当你点击Session Manager时,在注册表右边的显示栏中,你 会看到PendingFileRenameOperations项.在该 值 下鼠标右键,选删除,然 后确定.注册表先不要急着关闭.这时,你 回到刚才的安装画面,点击下一步,发 现不再出现挂起提示了.然后接着按正常操作安装下去,应 该不会再出什么问题了(我的是这样).最 后到了安装完成画面,真是开心啊!这 时,你再关闭注册表就行了.

二、 提示“command line option syntax error,type command/? for help

    原因是SQL Server的安装文件放在中文目录下了,我们只需要将SQL Server安装文件放在英文目录下就不会出错了。

三、安装到最后提示失败!提示详细信息查看C:/WINDOWS/sqlstp.log日志。最后显示 [Microsoft] [ODBC 驱动程序管理器] 未发现数据源。方法如下:

    以下转自http://blog.csdn.net/AYongSoft/archive/2010/01/29/5268005.aspx 感谢这位老兄!

0
1、日志
正在启动?

Chinese_PRC_CI_AS

-m -Q -T4022 -T3659

正 在与服务?

driver={sql server};server=LZ01;UID=sa;PWD=;database=master

[Microsoft] [ODBC 驱动程序管理器] 未发现数据源

driver={sql server};server=LZ01;UID=sa;PWD=;database=master

[Microsoft] [ODBC 驱动程序管理器] 未发现数据源

driver={sql server};server=LZ01;UID=sa;PWD=;database=master

[Microsoft] [ODBC 驱动程序管理器] 未发现数据源

SQL Server 配置?

###############################################################################

17:00:08 Process Exit Code: (-1) 
17:01:41 安 装程序配置服务器失败。参考服务器错误日志和 C:/WINDOWS/sqlstp.log 了解更多信息。
17:01:41 Action CleanUpInstall:
17:01:41 C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/SqlSetup/Bin/scm.exe  -Silent 1 -Action 4 -Service SQLSERVERAGENT
17:01:41 Process Exit Code: (1060) 指 定的服务未安装。

17:01:41 C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/SqlSetup/Bin/scm.exe  -Silent 1 -Action 4 -Service MSSQLSERVER
17:01:41 Process Exit Code: (0) 
17:01:41 StatsGenerate returned: 2
17:01:41 StatsGenerate (0x0,0x1,0xf00,0x100,2052,303,0x0,0x1,0,0,0
17:01:41 StatsGenerate -1,Administrator)
17:01:41 Installation Failed.


建 议:

2、保存一下内容到一个.reg文件中,运行后可以成功安装
-----------------------------------------------
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC]

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI]

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/LocalServer]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/ODBC Data Sources]
"LocalServer"="SQL Server"
"TrioMotors"="Microsoft Access Driver (*.mdb)"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/ODBC File DSN]
"DefaultDSNDir"="C://Program Files//Common Files//ODBC//Data Sources"


[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/TrioMotors/Engines]

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/TrioMotors/Engines/Jet]
"ImplicitCommitSync"="Yes"
"MaxBufferSize"=dword:00000200
"PageTimeout"=dword:00000005
"Threads"=dword:00000003
"UserCommitSync"="Yes"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI]


[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver da Microsoft para arquivos texto (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver do Microsoft Access (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver do Microsoft dBase (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver do Microsoft Excel(*.xls)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver do Microsoft Paradox (*.db )]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver para o Microsoft Visual FoxPro]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Access Driver (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Access-Treiber (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft dBase Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft dBase VFP Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft dBase-Treiber (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Excel Driver (*.xls)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Excel-Treiber (*.xls)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft FoxPro VFP Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft ODBC for Oracle]
"UsageCount"=dword:00000001
"Driver"="C://WINDOWS//system32//msorcl32.dll"
"Setup"="C://WINDOWS//system32//msorcl32.dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="02.50"
"ConnectFunctions"="YYY"
"APILevel"="1"
"CpTimeout"="120"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Paradox Driver (*.db )]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Paradox-Treiber (*.db )]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Text Driver (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Text-Treiber (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//odbcjt32.dll"
"Setup"="C://WINDOWS//system32//odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Visual FoxPro Driver]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Microsoft Visual FoxPro-Treiber]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//vfpodbc.dll"
"Setup"="C://WINDOWS//system32//vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/MS Code Page Translator]
"Translator"="C://WINDOWS//system32//MSCPXL32.dll"
"Setup"="C://WINDOWS//system32//MSCPXL32.dll"
"UsageCount"=dword:00000002


[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/ODBC Core]
"UsageCount"=dword:00000002

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/ODBC Drivers]
"SQL Server"="Installed"
"Microsoft Access Driver (*.mdb)"="Installed"
"Microsoft Text Driver (*.txt; *.csv)"="Installed"
"Microsoft Excel Driver (*.xls)"="Installed"
"Microsoft dBase Driver (*.dbf)"="Installed"
"Microsoft Paradox Driver (*.db )"="Installed"
"Microsoft Visual FoxPro Driver"="Installed"
"Microsoft FoxPro VFP Driver (*.dbf)"="Installed"
"Microsoft dBase VFP Driver (*.dbf)"="Installed"
"Microsoft Access-Treiber (*.mdb)"="Installed"
"Microsoft Text-Treiber (*.txt; *.csv)"="Installed"
"Microsoft Excel-Treiber (*.xls)"="Installed"
"Microsoft dBase-Treiber (*.dbf)"="Installed"
"Microsoft Paradox-Treiber (*.db )"="Installed"
"Microsoft Visual FoxPro-Treiber"="Installed"
"Driver do Microsoft Access (*.mdb)"="Installed"
"Driver da Microsoft para arquivos texto (*.txt; *.csv)"="Installed"
"Driver do Microsoft Excel(*.xls)"="Installed"
"Driver do Microsoft dBase (*.dbf)"="Installed"
"Driver do Microsoft Paradox (*.db )"="Installed"
"Driver para o Microsoft Visual FoxPro"="Installed"
"Microsoft ODBC for Oracle"="Installed"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/ODBC Translators]
"MS Code Page Translator"="Installed"

[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/SQL Server]
"UsageCount"=dword:00000002
"Driver"="C://WINDOWS//system32//SQLSRV32.dll"
"Setup"="C://WINDOWS//system32//sqlsrv32.dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="03.50"
"ConnectFunctions"="YYY"
"APILevel"="2"
"CPTimeout"="60"

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值