sql程序安装配置服务器失败

sql程序安装配置服务器失败,第1张

1、卸载sql,如果没有卸载选项那直接删除sql的安装目录,2、删除注册表里 一切和sql server 有关的项 ,重启计算机。3、重新安装mssql。

不行的话把下列内容复制到文本文件后改后缀为reg 然后执行 安装mssql,或执行后重启计算机再安装mssql

Windows Registry Editor Version 500

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\LocalServer]

"Description"=""

"Server"="(Local)"

"Trusted_connection"=""

"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\ODBC Data Sources]

"LocalServer"="SQL Server"

"TrioMotors"="Microsoft Access Driver (mdb)"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\ODBC File DSN]

"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\TrioMotors\Engines]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\TrioMotors\Engines\Jet]

"ImplicitCommitSync"="Yes"

"MaxBufferSize"=dword:00000200

"PageTimeout"=dword:00000005

"Threads"=dword:00000003

"UserCommitSync"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver da Microsoft para arquivos texto (txt; csv)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odtext32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"=",asc,csv,tab,txt,csv"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver do Microsoft Access (mdb)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odbcjt32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="2"

"FileExtns"="mdb"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver do Microsoft dBase (dbf)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\oddbse32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="dbf,ndx,mdx"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver do Microsoft Excel(xls)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odexl32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="xls"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver do Microsoft Paradox (db )]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odpdx32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="db"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver para o Microsoft Visual FoxPro]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"

"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"

"APILevel"="0"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="dbf,cdx,idx,fpt"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Access Driver (mdb)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odbcjt32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="2"

"FileExtns"="mdb"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Access-Treiber (mdb)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odbcjt32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="2"

"FileExtns"="mdb"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft dBase Driver (dbf)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\oddbse32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="dbf,ndx,mdx"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft dBase VFP Driver (dbf)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"

"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"

"APILevel"="0"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="dbf,cdx,idx,fpt"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft dBase-Treiber (dbf)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\oddbse32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="dbf,ndx,mdx"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Excel Driver (xls)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odexl32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="xls"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Excel-Treiber (xls)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odexl32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="xls"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft FoxPro VFP Driver (dbf)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"

"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"

"APILevel"="0"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="dbf,cdx,idx,fpt"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft ODBC for Oracle]

"UsageCount"=dword:00000001

"Driver"="C:\\WINDOWS\\system32\\msorcl32dll"

"Setup"="C:\\WINDOWS\\system32\\msorcl32dll"

"SQLLevel"="1"

"FileUsage"="0"

"DriverODBCVer"="0250"

"ConnectFunctions"="YYY"

"APILevel"="1"

"CpTimeout"="120"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Paradox Driver (db )]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odpdx32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="db"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Paradox-Treiber (db )]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odpdx32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="db"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Text Driver (txt; csv)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odtext32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"=",asc,csv,tab,txt,csv"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Text-Treiber (txt; csv)]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"

"Setup"="C:\\WINDOWS\\system32\\odtext32dll"

"APILevel"="1"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"=",asc,csv,tab,txt,csv"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Visual FoxPro Driver]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"

"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"

"APILevel"="0"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="dbf,cdx,idx,fpt"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Visual FoxPro-Treiber]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"

"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"

"APILevel"="0"

"ConnectFunctions"="YYN"

"DriverODBCVer"="0250"

"FileUsage"="1"

"FileExtns"="dbf,cdx,idx,fpt"

"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\MS Code Page Translator]

"Translator"="C:\\WINDOWS\\system32\\MSCPXL32dll"

"Setup"="C:\\WINDOWS\\system32\\MSCPXL32dll"

"UsageCount"=dword:00000002

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\ODBC Core]

"UsageCount"=dword:00000002

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\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\ODBCINSTINI\ODBC Translators]

"MS Code Page Translator"="Installed"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\SQL Server]

"UsageCount"=dword:00000002

"Driver"="C:\\WINDOWS\\system32\\SQLSRV32dll"

"Setup"="C:\\WINDOWS\\system32\\sqlsrv32dll"

"SQLLevel"="1"

"FileUsage"="0"

"DriverODBCVer"="0350"

"ConnectFunctions"="YYY"

"APILevel"="2"

"CPTimeout"="60"

使用逆向思维来解决这个问题:

感觉你的这个问题可以使用sql中的变量来实现,

drop database @dataname

然后就是声明这个dataname了

declare @dataname varchar(10)

但是现在问题就是如何给变量@dataname赋值,你的意思是想象从控制台接收一个参数吧,然后实现删除数据库的效果吧

但是感觉数据库好像没有这样的功能,如果你有变成语言的基础,可以把数据库和变成语言结合起来的话,要实现这个效果的话,就非常的简单啦

我会java、c#不知道这两个语言你会不 如果你同意我的建议 你还是不会的话 你可以再联系我

但愿可以帮助你 谢谢

以上就是关于sql程序安装配置服务器失败全部的内容,包括:sql程序安装配置服务器失败、使用批处理命令,删除、分离指定SQL数据库的方法。、等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!

欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/sjk/9314520.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-04-27
下一篇 2023-04-27

发表评论

登录后才能评论

评论列表(0条)

保存