天天看點

SQL安裝時出錯,提示:安裝程式配置伺服器失敗 參考伺服器錯誤日志。針對其中一種情況的解決方法!

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

正在啟動?

Chinese_PRC_CI_AS

-m -Q -T4022 -T3659

正在與服務?

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

[Microsoft][ODBC 驅動程式管理器] 未發現資料源

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

[Microsoft][ODBC 驅動程式管理器] 未發現資料源

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

[Microsoft][ODBC 驅動程式管理器] 未發現資料源

SQL Server 配置?

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

22:11:37 Process Exit Code: (-1)

22:11:51 安裝程式配置伺服器失敗。參考伺服器錯誤日志和 C:/WINDOWS/sqlstp.log 了解更多資訊。

解決方法如下,将下面的代碼放在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"