sql安装程序配置服务器失败
关闭服务管理器--卸载(可用360)--删除相关文件及文件夹(sql文件夹)--清理注册表相关项--重启电脑--安装。
我遇到 过这种情况,反复试过好多次,有时一次不行2、3次有可能就行了,清理注册表时可用超级兔子清理,清理完还要删除注册表当中的一下几项:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
2000和mdse(一个小的数据库软件)容易出现上述情况,05以后的好像能好点。
希望能帮到你,其实你的操作系统要是没有太大的问题是不用重装系统的,重装完很多东西无法恢复。
SQLserver2008是win7系统电脑的一款数据管理系统,功能十分强大,实用性也是非常强的。很多用户选择在自己的win7旗舰版电脑中安装这个数据库系统,有些用户在win7系统安装SQLserver2008提示重启计算机失败,该如何解决呢?小编对此问题进行研究,整理出下面几种解决方法,有需要的用户一起来学习下吧。
解决方法一:
1、同时按下win7旗舰版电脑键盘上的win+R快捷键打开电脑的运行窗口,在打开的运行窗口中,输入regedit并单击回车,这样就可以打开win7旗舰版电脑的注册表编辑器窗口了
2、在打开的注册表编辑器窗口中,点击展开左侧菜单中的HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MicrosoftSQLServer;
3、然后在这个MicrosoftSQLServer选项上点击鼠标右键,选择删除;
4、再次在左侧菜单中定位到HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager,然后在右侧找到PendingFileRenameOperations,然后点击右键将PendingFileRenameOperations删除就可以了;
解决方法二:
1、同时按下win7旗舰版电脑键盘上的win+R快捷键打开电脑的运行窗口,在打开的运行窗口中,输入gpeditmsc并单击回车,这样就可以打开win7旗舰版电脑的组策略编辑器窗口了;
2、在打开的组策略编辑器窗口中,咱们依次点击展开左侧菜单中的计算机配置——管理模板——windows组件,之后,咱们在左侧窗口中找到windowsmediaplayer项并展开;
3、之后在右侧窗口中找到“防止自动更新项”并双击打开,在打开的编辑窗口中,咱们将默认设置更改为已启用,然后点击确定保存即可。
如果遇到win7系统安装SQLserver2008提示重启计算机失败的问题,使用上述方法教程即可轻松解决问题了,希望本教程内容能够帮助到大家!
用户发现在安装sql2008过程中出现了错误服务,从而导致无法正常启动sql服务,这样就会导致白白安装,没有产生任何效果,下面我就给大家提供详细的解决步骤。
sql2008r2安装出现以下错误服务没有及时响应启动解决方法
1、点击SqlServer,查看windows错误日志,
2、错误的日志信息都会显示出来,
3、接着选择“mssqlserver”协议,右侧选择“TCP/IP协议”,
4、然后右击“TCP/IP协议”,点击“属性”按钮,修改连接数据库端口,
5、在弹出的对话框中找到“IP3”,更改为电脑的IP或者是127001,
6、将“IPall”中端口改为“1433”,
7、点击“确定”按钮,
8、重新启动“SqlServer(mssqlserver)”服务。
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"
1、先添加/删除程序中彻底删除sql server。
2、将没有删除的sql server目录也删除掉。
3、打开注册表编辑器,在HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ Session Manager中找到PendingFileRenameOperations项目,并删除它。这样就可以清除安装暂挂项目。
4、删除注册表中跟sql server相关的文件 SQL Server 无法安装,重新启动了计算机之后,就可以了。
SQLserver 2000中出现“指定的服务并未以已安装的服务存在”最终解决方案
一、将计算机名改成大写。
二、将sql server的安装文件夹和数据文件夹全部删除
三、用如下方法对付安装挂起问题:
1、在开始->运行中输入regedit
2、到HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager 位置
3、选择文件->导出,保存(安全起见)
4、在右边窗口右击PendingFileRenameOperations,选择删除,然后确认
四、用删除注册表中相关项解决多实例问题:
1、删除HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
2、删除HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
3、删除HKEY_LOCAL_USER\SOFTWARE\Microsoft\Microsoft SQL Server
4、 + HKEY_LOCAL_MACHINE
+ SOFTWART
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ ExceptionComponents
将 ExceptionComponents 下面的文件夹全部删除!
如 {60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
五、重新启动:
六、重新安装 SQL Server 2000
0条评论