SOL-SEVER2000不能安装的原因
一,这是最简单,最直接的方法,而且非常的有效,请仔细耐心,如果失败,多尝试几次 一直以来,在 安装 SQL时,总会时不时提示 安装 程序被挂起的问题,害得我装了N次的系统,就在前几天晚上照样害我三点钟才睡,最终我上网查看了很多资料之后总结如下,希望对大
一,这是最简单,最直接的方法,而且非常的有效,请仔细耐心,如果失败,多尝试几次
一直以来,在安装SQL时,总会时不时提示安装程序被挂起的问题,害得我装了N次的系统,就在前几天晚上照样害我三点钟才睡,最终我上网查看了很多资料之后总结如下,希望对大家有所帮助:
今天在服务器上的SQL server挂了之后,重新装了,可老提示什么狗P程序被挂起的信息,最后不得不细找原因,功夫不负有心人,终于找出了病症所在,K,我要早知道这么简单,就再也不装系统了.....汗死,详情如下,做个备份,以便今后再碰到类似问题有地方查!
1、先运行你的安装程序,当提示挂起时,点击“确定”,切记,不要退出安装程序,用ALT+Tal键切换,点击“开始》运行”,输入“regedit”,打开注册表
2、找到目录HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager
3、删除其中的“PendingFileRenameOperations”(在这里说明一下,PendingFileRenameOperations文件位于Session Manager右侧,即当你点击Session Manager时,在右边就可以看到了)
4、关闭注册表
5、重新开始安装SQL Server 2000,一切OK了。简单吧
6、问题解决了,哈哈(如果上述步骤没能解决你问题,请继续往后看)
二、我是在WIN2003下安装的SQL2000,不用管"...SQL2000SP2不能安装在WIN2003下.."的提示,点继续,等安装完后再马上打上SP3,没有问题!
只是在安装过程中还出现了这个错误:
安装程序配置服务器失败。参考服务器错误日志和C:/WINNT/sqlstp.log 了解更多信息.
WINNT目录下的sqlstp.log中最后是这样的错误信息:
正在启动?
Chinese_PRC_CI_AS
-m -Q -T4022 -T3659
正在与服务?
driver={sql server};server=GH;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]一般性网络错误。
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
driver={sql server};server=GH;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]一般性网络错误。
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
driver={sql server};server=GH;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]一般性网络错误。
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
SQL Server 配置?
####################################################
09:23:53 Process Exit Code: (-1)
09:24:14 安装程序配置服务器失败。参考服务器错误日志和 C:/WINNT/sqlstp.log 了解更多信息。
09:24:14 Action CleanUpInstall:
09:24:14 C:/WINNT/TEMP/SqlSetup/Bin/scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
09:24:14 Process Exit Code: (1060) 指定的服务并未以已安装的服务存在。
09:24:14 C:/WINNT/TEMP/SqlSetup/Bin/scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
09:24:14 Process Exit Code: (0)
09:24:14 StatsGenerate returned: 2
09:24:14 StatsGenerate (0x0,0x1,0xf0000000,0x400,2052,303,0x0,0x1,0,0,0
09:24:14 StatsGenerate -1,Administrator)
09:24:14 Installation Failed.
解决方法:
首先把安装目录和C:/Program Files下的Microsoft SQL Server文件夹删了,删除在current_user和local_machine/software/microsoft/ 下有关 Microsoft sql server 全部信息,然后
1 打开注册表
在"开始"--"运行"键入 "regedit"
2 按下列顺序点击打开
+ HKEY_LOCAL_MACHINE
+ SOFTWART
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ ExceptionComponents
3 将 ExceptionComponents 下面的文件夹全部删除!
如 {60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
.......
4 重新启动:
5 重新安装 SQL Server 2000
另外在一个BLOG上看到的一个说法:
问题的原因:
此问题属于sql server的bug, GetComputerName 用于获取本地计算机名。客户端网络库组件 (DBMSLPCn.dll) 将该名称转换为全部大写。服务器网络库组件 (SSMSLPCn.dll) 保留返回时的名称。
当 Windows 计算机名称包含大写字母和小写字母或者都是小写字母时安装会失败,提示一般性网络错误!
解决办法就是将计算机名称改为全部大写!
我便照着将我电脑的名称改为大写,然后重启,刚才的网络错误问题没了。但又提示我 sa 登录失败。 奇怪了,我重新安装指定的是空密码,怎么安装程序自己也会sa登录失败呢?后来才想起来,卸载Sql Server 是为了保住我的数据,就偷懒没有将原先Sql Server 安装目录下的Data文件夹内的文件删除,master.mdf 和master.ldf都在。 以前的的Sql Server是设了密码的。于是感快将这两个文件删除。再重新安装一次,OK! 安装成功.
总结:
1、 以后计算机名称一定用大写,免得惹来不必要的麻烦.
2、重装Sql Server时一定要记得将master.mdf 和master.ldf删除。
注: 我的计算机名称也是小写,但我并没有把计算机名称换成大写,只是在SQL安装过程中把用户名改成了大写,再按照上面的做法删除文件夹和清除注册表后安装成功的,所以我觉得以上的说法值得探讨!
以下还收集一些SQL2000安装程序配置服务器失败的一些解决方法:
1. sql server 2000安装出错,无法找到动态链接库sqlunirl.dll
安装文件肯定没有错,因为以前安装过,绝对可以用,机子之前有装了sql server 2000,而且可以正常使用,只是今天突然无法连接到本地数据库,打算重装,我删了program files里的ms sql的目录,然后重装sql,结果在最后一步的时候提示,无法完成配置。后来又删除了一些注册表中的sql server信息(有备份注表),再安装时,就出现这样的提示了,更糟的是,备份的注册表却无法还原
============================
现在问题解决了,总结了一些经验
当安装时出现MDAC组件安装失败时,试着修复或重装microsoft office
当你想重装sql server,而安装时又出现“您的机子上已经安装有一个实例”的提示时,可以删除program files/Microsoft SQL Server文件夹,再安装
当出现某某动态链接文件找不到时,可以试着在sql server的安装文件中找到这个文件,复制到系统目录下的system和system32文件夹中(一般在出现这个错误消息时,都会提示哪几个文件夹下缺少这个文件)
当出现安装程序配置服务器失败时,可以试着用一下方法解决
此错误消息可以在系统目录下找到,例如我的系统是win2000,则该文件在C:/WINNT/sqlstp.log
失败一:
正在与服务?
driver={sql server};server=ZHL;UID=sa;PWD=;database=master
[Microsoft][ODBC 驱动程序 管理器] 驱动程序的 SQLAllocHandle on SQL_H
driver={sql server};server=ZHL;UID=sa;PWD=;database=master
[Microsoft][ODBC 驱动程序 管理器] 驱动程序的 SQLAllocHandle on SQL_H
driver={sql server};server=ZHL;UID=sa;PWD=;database=master
[Microsoft][ODBC 驱动程序 管理器] 驱动程序的 SQLAllocHandle on SQL_H
SQL Server 配置?
###############################################################################
13:40:06 Process Exit Code: (-1)
13:40:09 安装程序配置服务器失败。参考服务器错误日志和 C:/WINNT/sqlstp.log 了解更多信息。
13:40:09 Action CleanUpInstall:
当出现这个错误时,试一下重装系统文件
我的机子是win2000,在dos下重新运行win2000的安装,然后选择修复,而不是全新安装
修复系统文件之后,再装sql server,则不会出现此错误消息
失败二:
正在与服务?
driver={sql server};server=ZHL;UID=sa;PWD=;database=master
[Microsoft][ODBC 驱动程序 管理器] 未发现数据源
driver={sql server};server=ZHL;UID=sa;PWD=;database=master
[Microsoft][ODBC 驱动程序 管理器] 未发现数据源
driver={sql server};server=ZHL;UID=sa;PWD=;database=master
[Microsoft][ODBC 驱动程序 管理器] 未发现数据源
SQL Server 配置?
###############################################################################
13:50:07 Process Exit Code: (-1)
13:50:10 安装程序配置服务器失败。参考服务器错误日志和 C:/WINNT/sqlstp.log 了解更多信息。
13:50:10 Action CleanUpInstall:
当出现这个错误时,是因为在注册表删除了HKEY_LOCAL_MACHINE/SOFTWARE/ODBC中有关sql sever的内容
这时可以选择修复注册表,或安装ODBC修复工具.
失败三:
在与服务?
driver={sql server};server=ZHL;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]连接?
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (ReadFile()).
driver={sql server};server=ZHL;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]连接?
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).
driver={sql server};server=ZHL;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]连接?
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).
SQL Server 配置?
###############################################################################
17:17:41 Process Exit Code: (-1)
17:17:45 安装程序配置服务器失败。参考服务器错误日志和
当出现这个错误时,必须安装ODBC修复工具
另外在安装过程中还出现这个错误:
装SQL时出现
SQL Redist
command line option syntax error
Type command /? for help
不知道是什么原因,但是并不影响安装,点确定后可以继续,至于是什么原因还不明白!???
1。将Program files下的SQL安装目录删除(此处如果有重要的数据,请先备份)
C:/Program Files/Microsoft SQL Server/80/Tools。
C:/Program Files/Microsoft SQL Server/MSSQL。
2。注册表中的相关信息删除:
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer。
HKEY_LOCAL_MACHINE/System/CurrentControlSet/Services/MSDTC。
3。HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager中找到PendingFileRenameOperations项目,并删除它。这样就可以清除安装暂挂项目
4。HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows/CurrentVersion/setup
删除ExceptionComponents
这个项目下的内容可能很多,只有在上面几个办法不行的情况下,使用此方法(注意不要全部删除)
删除内容前先看下内容说明
5。Windows 目录中的 Sqlstp.log 文件,该文件列出了安装程序所执行的操作的详细信息,并包含安装期间遇到的所有错误。通过检查该文件,可以详细了解安装在什么地方失败、为什么失败。
6。SQL安装的时的错误信息保存在一个叫Errorlog的日志文件中,默认情况下该文件位于 Program Files/Microsoft SQL Server/Mssql/Log 目录中。该错误日志包含安装程序试图启动 SQL Server 时 SQL Server 所遇到的错误,这些信息可以帮助您深入检查错误原因。
7。需要检查的另一个组件是 Microsoft 数据访问组件 (MDAC) 安装程序,它作为 SQL Server 2000 安装程序的一部分启动。SQL Server 2000 安装程序会安装 MDAC 2.6。MDAC 安装程序会创建名为 Dasetup.log 的单独的日志文件;您可以查看此日志文件并确保 MDAC 安装程序没有出现问题。
下面是彻底删除SQL的办法
http://blog.csdn.net/sxycgxj/archive/2006/04/26/677695.aspx
http://blog.csdn.net/sxycgxj/archive/2005/09/30/492690.aspx
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Why does wireless screencasting fail to connect? Some friends have reported that the connection fails when using wireless screen mirroring. What is going on? What should I do if the wireless screen mirroring connection fails? Please confirm whether your computer, TV and mobile phone are connected to the same WiFi network. Screen mirroring software requires devices to be on the same network to work properly, and Quick Screen Mirroring is no exception. Therefore, please quickly check your network settings. It is important to determine whether the screen mirroring function is supported. Smart TVs and mobile phones usually support DLNA or AirPlay functionality. If the screencast function is not supported, screencasting will not be possible. Confirm whether the device is connected correctly: There may be multiple devices under the same WiFi. Make sure you are connecting to the device you want to share the screen with. 4. Ensure that the network

When connecting a printer to a local area network and starting a print job, some minor problems may occur. For example, the problem "wpsoffice cannot start the print job..." occasionally occurs, resulting in the inability to print out files, etc., delaying our work and study, and causing a bad impact. , let me tell you how to solve the problem that wpsoffice cannot start the print job? Of course, you can upgrade the software or upgrade the driver to solve the problem, but this will take you a long time. Below I will give you a solution that can be solved in minutes. First of all, I noticed that wpsoffice cannot start the print job, resulting in the inability to print. To solve this problem, we need to investigate one by one. Also, make sure the printer is powered on and connected. Generally, abnormal connection will cause

A Comprehensive Guide to PHP 500 Errors: Causes, Diagnosis, and Fixes During PHP development, we often encounter errors with HTTP status code 500. This error is usually called "500InternalServerError", which means that some unknown errors occurred while processing the request on the server side. In this article, we will explore the common causes of PHP500 errors, how to diagnose them, and how to fix them, and provide specific code examples for reference. Common causes of 1.500 errors 1.

Some users may encounter slow charging speeds when using Apple phones. There are many reasons for this problem. It may be caused by low power of the charging device, device failure, problems with the USB interface of the mobile phone, or even battery aging and other factors. Why does Apple mobile phone charge very slowly? Answer: charging equipment problem, mobile phone hardware problem, mobile phone system problem. 1. When users use charging equipment with relatively low power, the charging speed of the mobile phone will be very slow. 2. Using third-party inferior chargers or charging cables will also cause slow charging. 3. It is recommended that users use the official original charger, or replace it with a regular certified high-power charger. 4. There is a problem with the user’s mobile phone hardware. For example, the USB interface of the mobile phone cannot be contacted.

I believe many friends have encountered the problem of system blue screen, but I don’t know what is the cause of win11 blue screen. In fact, there are many reasons for system blue screen, and we can investigate and solve them in order. Reasons for win11 blue screen: 1. Insufficient memory 1. It may occur when running too many software or the game consumes too much memory. 2. Especially now there is a memory overflow bug in win11, so it is very likely to be encountered. 3. At this time, you can try to set up virtual memory to solve the problem, but the best way is to upgrade the memory module. 2. CPU overclocking and overheating 1. The causes of CPU problems are actually similar to those of memory. 2. It usually occurs when using post-processing, modeling and other software, or when playing large-scale games. 3. If the CPU consumption is too high, a blue screen will appear.

Recently, a friend encountered the problem of Win11 automatically shutting down after updating the system. In many cases, it happens when playing games. I don’t know what caused it. In fact, this may be caused by insufficient computer configuration or system failure. Let’s take a look at the causes and solutions. Why does win11 automatically shut down? 1. Insufficient configuration 1. Windows 11 system has higher CPU and memory requirements than Windows 10. 2. Especially when running large-scale games and other tasks, it is very easy to automatically shut down. 3. Users can try to restore the usage status before automatic shutdown by right-clicking the start menu icon and opening the "Task Manager" page. 4. Let’s check the CPU, memory, and disk on this page.

Explore the causes and solutions of HTTP status code 550 Introduction: In network communications, HTTP status codes play an important role and are used to indicate the results of the server processing the request. Among them, HTTP status code 550 is a relatively rare status code that is usually related to the server refusing to execute the request. This article will explore the causes of HTTP status code 550 and provide solutions. 1. The basic concept of HTTP status code. Before understanding the HTTP status code 550, let us first briefly understand the basic concept of HTTP status code.

Some friends encountered the problem of installation failure when installing Windows 10 drivers, but they did not know the cause of the failure or how to solve it. There are several different reasons for this problem. Please follow me to find out below. Reasons why win10 driver installation fails: 1. System version Currently, Windows 10 system already has the function of automatically installing drivers. The introduction of this feature eliminates the need for users to manually search and install drivers when installing the system. The system will automatically detect and install appropriate drivers, providing a more convenient experience. If your driver installation fails, one solution is to try updating your system. This may fix some system-related issues, allowing the driver to
