WIN2003安装Mssql server2000失败问题解决

最新推荐文章于 2020-11-02 20:58:50 发布

yuzhic

最新推荐文章于 2020-11-02 20:58:50 发布

阅读量1.8k

点赞数

分类专栏： 3.1 Mssql server 文章标签： microsoft sql server c access excel oracle

本文链接：https://blog.csdn.net/yuzhic/article/details/1556052

版权

在安装Mssql server2000时遇到问题？确保你的WIN2003已更新到SP1，同时在系统属性中正确配置数据执行保护DEP。检查ODBC数据源驱动程序库，确认驱动存在。通过修改注册表，如[HKEY_LOCAL_MACHINE/SOFTWARE/ODBC]等项，可帮助解决安装问题。

摘要由CSDN通过智能技术生成

1、WIN2003需要打上sp1补丁。

2、注意数据执行保护里的设置。右键点“我的电脑”——“属性”——“高级”，“性能”框里的“设置”——“数据执行保护”，需要选择“仅为基本windows程序和服务启用DEP（T）”。设置完成后，查看“系统ODBC”里面的“DSN”的数据源驱动程序库里是否有内置的驱动程序，有则可安装。

3、修改注册表：（以下为注册表文件）

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"=