Solution for installing sp4 patch in SQLServer: bitsCN.com
Problem: When installing the SP4 patch, the system always reports a verification password error.
I checked the information online and found it was a small bug.
Follow the steps below to install properly.
SQL Server patch installation FAQ
SQL Server patch installation FAQ: 1. check the patch version of SQL Server
The patch version check of SQL Server is not as direct as the Windows patch version check. if a system administrator does not know the patch number corresponding to the SQL Server version, it may also encounter some trouble, therefore, it is explained that using this method to identify machines is a safe way and will not affect the system.
◆ 1. log on to SQL Server using Isql or SQL query Analyzer. if Isql is used, enter isql-U sa in the cmd window, and then enter the password; if you use the SQL query analyzer, start it from the program and enter the sa and password (you can also use windows for verification ).
◆ 2. input in ISQL:
Select @ Version;
Go
Or input in the SQL query analyzer (in fact, if you don't want to enter it, you just need to open the help information :))
Select @ Version;
Then, press the execution button;
The SQL version information is returned as follows:
Microsoft SQL Server 2000-8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
8.00.760 indicates the SQL Server version and patch number. The relationship is as follows:
8.00.194---SQL Server 2000 RTM
8.00.384---(SP1)
8.00.534---(SP2)
8.00.760---(SP3)
In this way, we can see the correct version and patch number of SQL Server.
We can also use xp_msver to see more detailed information.
II. FAQs during patch installation
If the following error occurs during patch installation:
◆ 1. during the installation process, the following steps show:
A. restart the machine and install it again. if the error persists, follow these steps:
Enter regedit
C. go to the HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager location.
D. Select File-> inverted, save
E. right-click PendingFileRenameOperations in the right window, select Delete, and then confirm
F. restart the installation and solve the problem.
If the problem persists, check whether the value exists in other registries. If yes, delete it.
◆ 2. when installing SQL Server SP3, sometimes there will be a password error in both windows Authentication and hybrid authentication. in this case, check sqlsp in the temporary directory. out, you will find the following description:
[TCP/IP Sockets] Specified SQL server not found.
[TCP/IP Sockets] ConnectionOpen (Connect ()).
In fact, this is a small bug in SQL Server SP3. when installing sp3, you do not listen to the TCP/IP port. you can follow these steps:
◆ 1. enable the SQL server client network utility and server network tool to ensure that the enabled protocol contains name pipe, which is placed first.
◆ 2. ensure that [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer/Client/ConnectTo]
"DSQUERY" = "DBNETLIB ".
If not, create your own
◆ 3. stop mssql.
◆ 4. install the SDK.
In this way, you can install it correctly.
BitsCN.com