SQL Server Patch Installation FAQ (Update)
Create time: 2003-01-27
Article attribute: original
Article Source:
http://www.xfocus.net
Article submission:
Benjurry (Benjurry_AT_XFOCUS.ORG)
SQL Server patch version of the examination and installation process
If you have any questions, you can contact: Benjurry@xfocus.org or in the forum
First, the SQL Server patch version check
SQL Server patch version check is not as direct, a system administrator, if you don't understand the patch number corresponding to the SQL Server version, so you can explain it.
It is a safe way to discriminate the machine through such a method, and there is no impact on the system.
1. Log in to SQL Server with the ISQL or SQL query analyzer. If you use ISQL, enter ISQL -U SA in the CMD window, then enter your password, enter; if you use the SQL query analyzer, start, enter, enter SA and passwords (you can also verify using Windows).
2, enter in isql:
SELECT @@ Version;
Go
Or input in the SQL query analyzer (in fact, if you don't want to enter, just open your help, you can :))
SELECT @@ Version;
Then press execution;
The version information of SQL is returned at this time, 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)
The 8.00.760 is the version and patch number of SQL Server. The correspondence is as follows:
8.00.194 ------- SQL Server 2000 RTM 8.00.384 ------- (SP1) 8.00.534 ------- (SP2) 8.00.760 ------- (SP3)
This way we can see the correct version and patch number of SQL Server.
We can also see more detailed information with XP_MSVER.
Second, the common problem during the patch installation
If you encounter the following matches when installing the patch:
1. "The previous program creates a suspended file operation during the installation process. Before running the installer", follow these steps:
a, restart the machine, then install, if there is still this error, please follow the steps below
b, enter regedit in the start -> operation
C, to HKEY_LOCAL_MACHINE / SYSTEM / CURRENTCONTROLSET / CONTROL / Session Manager location
D, select file -> pour out, save
E. Right-click PENDINGFILENAMEOPERATIONS to right, select Delete, and then confirm
f, restart installation, problem solving
If there is also the same problem, please check if there is this value in other registry, if you have any deletion.
2, in installing SQL Server SP3, sometimes appears: Whether you use Windows certification or mixing authentication, you have a password error. At this time, 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 of SQL Server SP3. When installing SP3, there is no listening to the TCP / IP port, you can follow the steps below:
1. Open the SQL Server Client Network Utility and Server Network Tool to ensure that the Name Pipe is included in the protocol enabled, and the location is in the first.
2, make sure [HKEY_LOCAL_MACHINE / SOFTWARE / Microsoft / MSSQLServer / Client / Connectto]
"Dsquery" = "dbnetlib".
If not, please build yourself
3, stop MSSQL.
4, make installation.
This will be installed correctly.
