Solution for SQL Server installation SP4 patch error

Problem: When installing the SP4 patch, always report the authentication password error.

On the Internet to check the information, found to be a small bug.

Follow the operation, the installation is normal.

SQL Server Patch installation FAQ: First, SQL Server patch version check

SQL Server patch version check is not as direct as Windows patch version check, a system administrator, if you do not understand the SQL Server version of the corresponding patch number, may also encounter a bit of trouble, so in this explanation, this way to identify the machine is a safe way, Does not have any effect on the system.

1, with isql or SQL Query Analyzer login to SQL Server, if it is using isql, please enter the Isql-u sa in the cmd window, then enter the password, enter; If you are using SQL Query Analyzer, start from the program, Enter the SA and password (you can also use Windows authentication).

2, in the isql input:

SELECT @ @Version;

Go

or SQL Query Analyzer input (in fact, if you do not want to enter, just open the help of the About on it:))

SELECT @ @Version;

followed by execution;

The version information for SQL is returned as follows:

Microsoft SQL Server 2000-8.00.760 (Intel X86) Dec 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterp Rise Edition on Windows NT 5.0 (build 2195:service Pack 3)

The 8.00.760 is the version and patch number of SQL Server. The corresponding relationship is as follows:

8.00.194-—————— SQL Server Watts RTM

8.00.384-—————— (SP1)

8.00.534-—————— (SP2)

8.00.760-—————— (SP3)

So we can see the correct version and patch number of SQL Server.

We can also use xp_msver to see more detailed information.