I have patched my MS SQL 2000 DB from SP2 to SP3.
I noticed from the enterprise manager the patch level indicates
8.00.760 (SP3).
However, using microsofts type 4 JDBC driver to connect to SQL2000, I got the following info when I used one of the APIs to retrieve the database version :
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3) .
Now... which one is having the bug? MS JDBC driver or MS SQL 2000 SP3 ??8.00.760 = 2000 SP3. JDBC was written before SP3.
Look at %windir%\sqlsp.log to see SP3 is correctly installed.|||Originally posted by ispaleny
8.00.760 = 2000 SP3. JDBC was written before SP3.
Look at %windir%\sqlsp.log to see SP3 is correctly installed.
Indeed Type 4 MS JDBC driver is written b4 service pack 3.
However, after patching MS SQL 2000, the driver should correctly retrieve the info from SQL 2000. Don't suppose that the JDBC driver has that value hard-coded in its coding?
Probably I would temporary revert to the JDBC-ODBC bridge to do a simple check..|||I tried to patch SP3 on MS sql 2000 standard edition, the JDBC driver reports it correctly.
Thus, seems like the only problem occurs on my MS Sql2000 Enterprise Edition.
Showing posts with label patch. Show all posts
Showing posts with label patch. Show all posts
Monday, February 20, 2012
MS Security patch MS03-031
I am trying to install ms03-031 (q815495) on a couple of our sql servers and
get the following error message:
'No sql server instances installed on this computer qualify for this Hotfix.
Check the version, language and
service pack requirement for this Hotfix', and the patch does not go on. I h
ave successfully put this fix
onto 35 other SQL Server 2000 SP3 servers.
The two I am getting the errors on are SQL Server 2000, sp3, and the languag
e is English. I cant seem to find
any log files to point me any Further. Would appreciate any suggestions, thi
ngs to check, etc. to find why we are getting
this error. Thanks, Johnlogfiles are put in c:\%windows%\sqlhotfix
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"John Anthony" <anonymous@.discussions.microsoft.com> wrote in message
news:EB38C53E-02C2-4E78-88EB-9D915FC06975@.microsoft.com...
and get the following error message:
Hotfix. Check the version, language and
have successfully put this fix
language is English. I cant seem to find
things to check, etc. to find why we are getting
Here is the tail end, where the error occurs.
Im not sure what it is saying. We are running SQL Server 2000 SE, product ve
rsion 8.00.760(sp3).
First error seems to be a product code issue. Any suggestions on how to fix
or what to do next
would be gratly appreciated. thanks, John.
<Func Name='CService::~CService'><Func Name='GetProductCodeForInstance'><End
Func Name='GetProductCodeForInstance' Return='2' GetLastError='997'><EndFunc
Name='PerformSQLDetection' Return='0' GetLastError='997'><Func Name='Qualif
ySQLComputer'><Func Name='Q
ualifySQLInstance'>
Verifying Instance MSSQLSERVER to see if it qualifies for this hotfix
Instance MSSQLSERVER does not meet the requirements for this HotFix or there
is no such instance installed on this computer
<EndFunc Name='QualifySQLInstance' Return='87' GetLastError='997'>
HotFix Installer did not find any installation or instance of SQL that quali
fies for this hotfix
<EndFunc Name='QualifySQLComputer' Return='1168' GetLastError='997'>
No components of SQL found on this computer that qualifies for this package.
<EndFunc Name='SQLHotfix' Return='1168' GetLastError='997'><EndFunc Name='Ha
ndlePackage' Return='1168' GetLastError='997'>
And:
Verifying Instance MSSQLSERVER to see if it qualifies for this hotfix
Instance MSSQLSERVER does not meet the requirements for this HotFix or there
is no such instance installed on this computer
<EndFunc Name='QualifySQLInstance' Return='87' GetLastError='997'>
HotFix Installer did not find any installation or instance of SQL that quali
fies for this hotfix
<EndFunc Name='QualifySQLComputer' Return='1168' GetLastError='997'>
No components of SQL found on this computer that qualifies for this package.
<EndFunc Name='SQLHotfix' Return='1168' GetLastError='997'><EndFunc Name='Ha
ndlePackage' Return='1168' GetLastError='997'>
=== Completed processing package defined in Hotfix2.inf with return code: 11
68
=== Of the 2 packages no package qualified to run on this computer
<EndFunc Name='ProcessPackages' Return='1168' GetLastError='1813'><EndFunc N
ame='WinMain' Return='1168' GetLastError='1813'>|||Have you run SQLDiag.exe on the machines that are having problems and
reviewed the output of SQLdiag.txt?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Reviewed output of SQLDiag.txt and nothing stands out. Compared with other S
P3 systems, and everything seems the
same. Could you please advise what to do next, Thanks, John|||Attach the SQLdiag.txt . I'd like to take a look.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
Here is the output of the hot fix. I cant seem to attach the sqldiag.txt her
e. Can I email it? Thanks for looking at this.
John.
Microsoft SQL Server Group of Products HotFix beginning Mon Dec 08 13:40:43
2003
<Func Name='WinMain'><Func Name='InitGlobals'>
OS Detected: Windows 2000 family
<EndFunc Name='InitGlobals' Return='0' GetLastError='203'><Func Name='Proces
sPackages'><Func Name='LoadPackages'><Func Name='ReadPackageInformation'><En
dFunc Name='ReadPackageInformation' Return='0' GetLastError='0'><Func Name='
ReadTargetProductInformatio
n'><EndFunc Name='ReadTargetProductInformation' Return='0' GetLastError='0'>
<Func Name='ReadPackageInformation'><EndFunc Name='ReadPackageInformation' R
eturn='0' GetLastError='0'><Func Name='ReadTargetProductInformation'><EndFun
c Name='ReadTargetProductIn
formation' Return='0' GetLastError='0'><EndFunc Name='LoadPackages' Return='
0' GetLastError='2'>
=== Processing package defined in Hotfix1.inf
<Func Name='HandlePackage'>
=== PACKAGE INFORMATION
=== Starting Hotfix Build : 0818
=== Hotfix KB Article : 815495
=== Installer Base: Hotfix
=== TARGET PRODUCT FOR THIS HOTFIX (Requirements)
=== Target Product Name : SQL
=== Target Product Version : 8.00
=== Target Product Service Pack requirement : 3
<Func Name='SQLHotfix'>
=== Hotfix targetting SQL Installations
<Func Name='PerformSQLDetection'><Func Name='CService::CService'><Func Name=
'CServiceNT::CServiceNT'><Func Name='CServiceNT::Open'><EndFunc Name='CServi
ceNT::Open' Return='T' GetLastError='997'><Func Name='CServiceNT::UpdateServ
iceStatus'><Func Name='CSer
viceNT::~CServiceNT'><Func Name='CServiceNT::Close'><EndFunc Name='CServiceN
T::Close' Return='T' GetLastError='997'><Func Name='CService::~CService'><Fu
nc Name='CService::CService'><Func Name='CServiceNT::CServiceNT'><Func Name=
'CServiceNT::Open'><EndFunc
Name='CServiceNT::Open' Return='T' GetLastError='997'><Func Name='CServiceNT
::UpdateServiceStatus'><Func Name='CServiceNT::~CServiceNT'><Func Name='CSer
viceNT::Close'><EndFunc Name='CServiceNT::Close' Return='T' GetLastError='99
7'><Func Name='CService::~
CService'><Func Name='GetProductCodeForInstance'><EndFunc Name='GetProductCo
deForInstance' Return='2' GetLastError='997'><EndFunc Name='PerformSQLDetect
ion' Return='0' GetLastError='997'><Func Name='CorrectCSDVersion'><EndFunc N
ame='CorrectCSDVersion' Ret
urn='0' GetLastError='0'><Func Name='PerformSQLDetection'><Func Name='CServi
ce::CService'><Func Name='CServiceNT::CServiceNT'><Func Name='CServiceNT::Op
en'><EndFunc Name='CServiceNT::Open' Return='T' GetLastError='997'><Func Nam
e='CServiceNT::UpdateServic
eStatus'><Func Name='CServiceNT::~CServiceNT'><Func Name='CServiceNT::Close'
><EndFunc Name='CServiceNT::Close' Return='T' GetLastError='997'><Func Name=
'CService::~CService'><Func Name='CService::CService'><Func Name='CServiceNT
::CServiceNT'><Func Name='C
ServiceNT::Open'><EndFunc Name='CServiceNT::Open' Return='T' GetLastError='9
97'><Func Name='CServiceNT::UpdateServiceStatus'><Func Name='CServiceNT::~CS
erviceNT'><Func Name='CServiceNT::Close'><EndFunc Name='CServiceNT::Close' R
eturn='T' GetLastError='997
'><Func Name='CService::~CService'><Func Name='GetProductCodeForInstance'><E
ndFunc Name='GetProductCodeForInstance' Return='2' GetLastError='997'><EndFu
nc Name='PerformSQLDetection' Return='0' GetLastError='997'><Func Name='Qual
ifySQLComputer'><Func Name=
'QualifySQLInstance'>
Verifying Instance MSSQLSERVER to see if it qualifies for this hotfix
Instance MSSQLSERVER does not meet the requirements for this HotFix or there
is no such instance installed on this computer
<EndFunc Name='QualifySQLInstance' Return='87' GetLastError='997'>
HotFix Installer did not find any installation or instance of SQL that quali
fies for this hotfix
<EndFunc Name='QualifySQLComputer' Return='1168' GetLastError='997'>
No components of SQL found on this computer that qualifies for this package.
<EndFunc Name='SQLHotfix' Return='1168' GetLastError='997'><EndFunc Name='Ha
ndlePackage' Return='1168' GetLastError='997'>
=== Completed processing package defined in Hotfix1.inf with return code: 11
68
=== Processing package defined in Hotfix2.inf
<Func Name='HandlePackage'>
=== PACKAGE INFORMATION
=== Starting Hotfix Build : 0818
=== Hotfix KB Article : 815495
=== Installer Base: Hotfix
=== TARGET PRODUCT FOR THIS HOTFIX (Requirements)
=== Target Product Name : SQL
=== Target Product Version : 8.00
=== Target Product Service Pack requirement : None
<Func Name='SQLHotfix'>
=== Hotfix targetting SQL Installations
<Func Name='PerformSQLDetection'><Func Name='CService::CService'><Func Name=
'CServiceNT::CServiceNT'><Func Name='CServiceNT::Open'><EndFunc Name='CServi
ceNT::Open' Return='T' GetLastError='997'><Func Name='CServiceNT::UpdateServ
iceStatus'><Func Name='CSer
viceNT::~CServiceNT'><Func Name='CServiceNT::Close'><EndFunc Name='CServiceN
T::Close' Return='T' GetLastError='997'><Func Name='CService::~CService'><Fu
nc Name='CService::CService'><Func Name='CServiceNT::CServiceNT'><Func Name=
'CServiceNT::Open'><EndFunc
Name='CServiceNT::Open' Return='T' GetLastError='997'><Func Name='CServiceNT
::UpdateServiceStatus'><Func Name='CServiceNT::~CServiceNT'><Func Name='CSer
viceNT::Close'><EndFunc Name='CServiceNT::Close' Return='T' GetLastError='99
7'><Func Name='CService::~
CService'><Func Name='GetProductCodeForInstance'><EndFunc Name='GetProductCo
deForInstance' Return='2' GetLastError='997'><EndFunc Name='PerformSQLDetect
ion' Return='0' GetLastError='997'><Func Name='CorrectCSDVersion'><EndFunc N
ame='CorrectCSDVersion' Ret
urn='0' GetLastError='0'><Func Name='PerformSQLDetection'><Func Name='CServi
ce::CService'><Func Name='CServiceNT::CServiceNT'><Func Name='CServiceNT::Op
en'><EndFunc Name='CServiceNT::Open' Return='T' GetLastError='997'><Func Nam
e='CServiceNT::UpdateServic
eStatus'><Func Name='CServiceNT::~CServiceNT'><Func Name='CServiceNT::Close'
><EndFunc Name='CServiceNT::Close' Return='T' GetLastError='997'><Func Name=
'CService::~CService'><Func Name='CService::CService'><Func Name='CServiceNT
::CServiceNT'><Func Name='C
ServiceNT::Open'><EndFunc Name='CServiceNT::Open' Return='T' GetLastError='9
97'><Func Name='CServiceNT::UpdateServiceStatus'><Func Name='CServiceNT::~CS
erviceNT'><Func Name='CServiceNT::Close'><EndFunc Name='CServiceNT::Close' R
eturn='T' GetLastError='997
'><Func Name='CService::~CService'><Func Name='GetProductCodeForInstance'><E
ndFunc Name='GetProductCodeForInstance' Return='2' GetLastError='997'><EndFu
nc Name='PerformSQLDetection' Return='0' GetLastError='997'><Func Name='Qual
ifySQLComputer'><Func Name=
'QualifySQLInstance'>
Verifying Instance MSSQLSERVER to see if it qualifies for this hotfix
Instance MSSQLSERVER does not meet the requirements for this HotFix or there
is no such instance installed on this computer
<EndFunc Name='QualifySQLInstance' Return='87' GetLastError='997'>
HotFix Installer did not find any installation or instance of SQL that quali
fies for this hotfix
<EndFunc Name='QualifySQLComputer' Return='1168' GetLastError='997'>
No components of SQL found on this computer that qualifies for this package.
<EndFunc Name='SQLHotfix' Return='1168' GetLastError='997'><EndFunc Name='Ha
ndlePackage' Return='1168' GetLastError='997'>
=== Completed processing package defined in Hotfix2.inf with return code: 11
68
=== Of the 2 packages no package qualified to run on this computer
<EndFunc Name='ProcessPackages' Return='1168' GetLastError='1813'><EndFunc N
ame='WinMain' Return='1168' GetLastError='1813'>|||Run the following command and post the results.
OSQL -E -Q"select @.@.version"
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Here is the output from the command. Thanks, John
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copy
right (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows N
T 5.0 (Build 2195: Service Pack 3)|||Review the following registry keys on your machine.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersion
\CSDVersion
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersion
\CSDVersionNumber
They should look like this:
CSDVersion (string) 8.00.761
CSDVersionNumber (dword) 300 (hex)
Update these keys as needed, and retry applying the Security Update.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
get the following error message:
'No sql server instances installed on this computer qualify for this Hotfix.
Check the version, language and
service pack requirement for this Hotfix', and the patch does not go on. I h
ave successfully put this fix
onto 35 other SQL Server 2000 SP3 servers.
The two I am getting the errors on are SQL Server 2000, sp3, and the languag
e is English. I cant seem to find
any log files to point me any Further. Would appreciate any suggestions, thi
ngs to check, etc. to find why we are getting
this error. Thanks, Johnlogfiles are put in c:\%windows%\sqlhotfix
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"John Anthony" <anonymous@.discussions.microsoft.com> wrote in message
news:EB38C53E-02C2-4E78-88EB-9D915FC06975@.microsoft.com...
quote:
> I am trying to install ms03-031 (q815495) on a couple of our sql servers
and get the following error message:
quote:
> 'No sql server instances installed on this computer qualify for this
Hotfix. Check the version, language and
quote:
> service pack requirement for this Hotfix', and the patch does not go on. I
have successfully put this fix
quote:
> onto 35 other SQL Server 2000 SP3 servers.
> The two I am getting the errors on are SQL Server 2000, sp3, and the
language is English. I cant seem to find
quote:
> any log files to point me any Further. Would appreciate any suggestions,
things to check, etc. to find why we are getting
quote:|||Thanks, found the log files.
> this error. Thanks, John
Here is the tail end, where the error occurs.
Im not sure what it is saying. We are running SQL Server 2000 SE, product ve
rsion 8.00.760(sp3).
First error seems to be a product code issue. Any suggestions on how to fix
or what to do next
would be gratly appreciated. thanks, John.
<Func Name='CService::~CService'><Func Name='GetProductCodeForInstance'><End
Func Name='GetProductCodeForInstance' Return='2' GetLastError='997'><EndFunc
Name='PerformSQLDetection' Return='0' GetLastError='997'><Func Name='Qualif
ySQLComputer'><Func Name='Q
ualifySQLInstance'>
Verifying Instance MSSQLSERVER to see if it qualifies for this hotfix
Instance MSSQLSERVER does not meet the requirements for this HotFix or there
is no such instance installed on this computer
<EndFunc Name='QualifySQLInstance' Return='87' GetLastError='997'>
HotFix Installer did not find any installation or instance of SQL that quali
fies for this hotfix
<EndFunc Name='QualifySQLComputer' Return='1168' GetLastError='997'>
No components of SQL found on this computer that qualifies for this package.
<EndFunc Name='SQLHotfix' Return='1168' GetLastError='997'><EndFunc Name='Ha
ndlePackage' Return='1168' GetLastError='997'>
And:
Verifying Instance MSSQLSERVER to see if it qualifies for this hotfix
Instance MSSQLSERVER does not meet the requirements for this HotFix or there
is no such instance installed on this computer
<EndFunc Name='QualifySQLInstance' Return='87' GetLastError='997'>
HotFix Installer did not find any installation or instance of SQL that quali
fies for this hotfix
<EndFunc Name='QualifySQLComputer' Return='1168' GetLastError='997'>
No components of SQL found on this computer that qualifies for this package.
<EndFunc Name='SQLHotfix' Return='1168' GetLastError='997'><EndFunc Name='Ha
ndlePackage' Return='1168' GetLastError='997'>
=== Completed processing package defined in Hotfix2.inf with return code: 11
68
=== Of the 2 packages no package qualified to run on this computer
<EndFunc Name='ProcessPackages' Return='1168' GetLastError='1813'><EndFunc N
ame='WinMain' Return='1168' GetLastError='1813'>|||Have you run SQLDiag.exe on the machines that are having problems and
reviewed the output of SQLdiag.txt?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Reviewed output of SQLDiag.txt and nothing stands out. Compared with other S
P3 systems, and everything seems the
same. Could you please advise what to do next, Thanks, John|||Attach the SQLdiag.txt . I'd like to take a look.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
Here is the output of the hot fix. I cant seem to attach the sqldiag.txt her
e. Can I email it? Thanks for looking at this.
John.
Microsoft SQL Server Group of Products HotFix beginning Mon Dec 08 13:40:43
2003
<Func Name='WinMain'><Func Name='InitGlobals'>
OS Detected: Windows 2000 family
<EndFunc Name='InitGlobals' Return='0' GetLastError='203'><Func Name='Proces
sPackages'><Func Name='LoadPackages'><Func Name='ReadPackageInformation'><En
dFunc Name='ReadPackageInformation' Return='0' GetLastError='0'><Func Name='
ReadTargetProductInformatio
n'><EndFunc Name='ReadTargetProductInformation' Return='0' GetLastError='0'>
<Func Name='ReadPackageInformation'><EndFunc Name='ReadPackageInformation' R
eturn='0' GetLastError='0'><Func Name='ReadTargetProductInformation'><EndFun
c Name='ReadTargetProductIn
formation' Return='0' GetLastError='0'><EndFunc Name='LoadPackages' Return='
0' GetLastError='2'>
=== Processing package defined in Hotfix1.inf
<Func Name='HandlePackage'>
=== PACKAGE INFORMATION
=== Starting Hotfix Build : 0818
=== Hotfix KB Article : 815495
=== Installer Base: Hotfix
=== TARGET PRODUCT FOR THIS HOTFIX (Requirements)
=== Target Product Name : SQL
=== Target Product Version : 8.00
=== Target Product Service Pack requirement : 3
<Func Name='SQLHotfix'>
=== Hotfix targetting SQL Installations
<Func Name='PerformSQLDetection'><Func Name='CService::CService'><Func Name=
'CServiceNT::CServiceNT'><Func Name='CServiceNT::Open'><EndFunc Name='CServi
ceNT::Open' Return='T' GetLastError='997'><Func Name='CServiceNT::UpdateServ
iceStatus'><Func Name='CSer
viceNT::~CServiceNT'><Func Name='CServiceNT::Close'><EndFunc Name='CServiceN
T::Close' Return='T' GetLastError='997'><Func Name='CService::~CService'><Fu
nc Name='CService::CService'><Func Name='CServiceNT::CServiceNT'><Func Name=
'CServiceNT::Open'><EndFunc
Name='CServiceNT::Open' Return='T' GetLastError='997'><Func Name='CServiceNT
::UpdateServiceStatus'><Func Name='CServiceNT::~CServiceNT'><Func Name='CSer
viceNT::Close'><EndFunc Name='CServiceNT::Close' Return='T' GetLastError='99
7'><Func Name='CService::~
CService'><Func Name='GetProductCodeForInstance'><EndFunc Name='GetProductCo
deForInstance' Return='2' GetLastError='997'><EndFunc Name='PerformSQLDetect
ion' Return='0' GetLastError='997'><Func Name='CorrectCSDVersion'><EndFunc N
ame='CorrectCSDVersion' Ret
urn='0' GetLastError='0'><Func Name='PerformSQLDetection'><Func Name='CServi
ce::CService'><Func Name='CServiceNT::CServiceNT'><Func Name='CServiceNT::Op
en'><EndFunc Name='CServiceNT::Open' Return='T' GetLastError='997'><Func Nam
e='CServiceNT::UpdateServic
eStatus'><Func Name='CServiceNT::~CServiceNT'><Func Name='CServiceNT::Close'
><EndFunc Name='CServiceNT::Close' Return='T' GetLastError='997'><Func Name=
'CService::~CService'><Func Name='CService::CService'><Func Name='CServiceNT
::CServiceNT'><Func Name='C
ServiceNT::Open'><EndFunc Name='CServiceNT::Open' Return='T' GetLastError='9
97'><Func Name='CServiceNT::UpdateServiceStatus'><Func Name='CServiceNT::~CS
erviceNT'><Func Name='CServiceNT::Close'><EndFunc Name='CServiceNT::Close' R
eturn='T' GetLastError='997
'><Func Name='CService::~CService'><Func Name='GetProductCodeForInstance'><E
ndFunc Name='GetProductCodeForInstance' Return='2' GetLastError='997'><EndFu
nc Name='PerformSQLDetection' Return='0' GetLastError='997'><Func Name='Qual
ifySQLComputer'><Func Name=
'QualifySQLInstance'>
Verifying Instance MSSQLSERVER to see if it qualifies for this hotfix
Instance MSSQLSERVER does not meet the requirements for this HotFix or there
is no such instance installed on this computer
<EndFunc Name='QualifySQLInstance' Return='87' GetLastError='997'>
HotFix Installer did not find any installation or instance of SQL that quali
fies for this hotfix
<EndFunc Name='QualifySQLComputer' Return='1168' GetLastError='997'>
No components of SQL found on this computer that qualifies for this package.
<EndFunc Name='SQLHotfix' Return='1168' GetLastError='997'><EndFunc Name='Ha
ndlePackage' Return='1168' GetLastError='997'>
=== Completed processing package defined in Hotfix1.inf with return code: 11
68
=== Processing package defined in Hotfix2.inf
<Func Name='HandlePackage'>
=== PACKAGE INFORMATION
=== Starting Hotfix Build : 0818
=== Hotfix KB Article : 815495
=== Installer Base: Hotfix
=== TARGET PRODUCT FOR THIS HOTFIX (Requirements)
=== Target Product Name : SQL
=== Target Product Version : 8.00
=== Target Product Service Pack requirement : None
<Func Name='SQLHotfix'>
=== Hotfix targetting SQL Installations
<Func Name='PerformSQLDetection'><Func Name='CService::CService'><Func Name=
'CServiceNT::CServiceNT'><Func Name='CServiceNT::Open'><EndFunc Name='CServi
ceNT::Open' Return='T' GetLastError='997'><Func Name='CServiceNT::UpdateServ
iceStatus'><Func Name='CSer
viceNT::~CServiceNT'><Func Name='CServiceNT::Close'><EndFunc Name='CServiceN
T::Close' Return='T' GetLastError='997'><Func Name='CService::~CService'><Fu
nc Name='CService::CService'><Func Name='CServiceNT::CServiceNT'><Func Name=
'CServiceNT::Open'><EndFunc
Name='CServiceNT::Open' Return='T' GetLastError='997'><Func Name='CServiceNT
::UpdateServiceStatus'><Func Name='CServiceNT::~CServiceNT'><Func Name='CSer
viceNT::Close'><EndFunc Name='CServiceNT::Close' Return='T' GetLastError='99
7'><Func Name='CService::~
CService'><Func Name='GetProductCodeForInstance'><EndFunc Name='GetProductCo
deForInstance' Return='2' GetLastError='997'><EndFunc Name='PerformSQLDetect
ion' Return='0' GetLastError='997'><Func Name='CorrectCSDVersion'><EndFunc N
ame='CorrectCSDVersion' Ret
urn='0' GetLastError='0'><Func Name='PerformSQLDetection'><Func Name='CServi
ce::CService'><Func Name='CServiceNT::CServiceNT'><Func Name='CServiceNT::Op
en'><EndFunc Name='CServiceNT::Open' Return='T' GetLastError='997'><Func Nam
e='CServiceNT::UpdateServic
eStatus'><Func Name='CServiceNT::~CServiceNT'><Func Name='CServiceNT::Close'
><EndFunc Name='CServiceNT::Close' Return='T' GetLastError='997'><Func Name=
'CService::~CService'><Func Name='CService::CService'><Func Name='CServiceNT
::CServiceNT'><Func Name='C
ServiceNT::Open'><EndFunc Name='CServiceNT::Open' Return='T' GetLastError='9
97'><Func Name='CServiceNT::UpdateServiceStatus'><Func Name='CServiceNT::~CS
erviceNT'><Func Name='CServiceNT::Close'><EndFunc Name='CServiceNT::Close' R
eturn='T' GetLastError='997
'><Func Name='CService::~CService'><Func Name='GetProductCodeForInstance'><E
ndFunc Name='GetProductCodeForInstance' Return='2' GetLastError='997'><EndFu
nc Name='PerformSQLDetection' Return='0' GetLastError='997'><Func Name='Qual
ifySQLComputer'><Func Name=
'QualifySQLInstance'>
Verifying Instance MSSQLSERVER to see if it qualifies for this hotfix
Instance MSSQLSERVER does not meet the requirements for this HotFix or there
is no such instance installed on this computer
<EndFunc Name='QualifySQLInstance' Return='87' GetLastError='997'>
HotFix Installer did not find any installation or instance of SQL that quali
fies for this hotfix
<EndFunc Name='QualifySQLComputer' Return='1168' GetLastError='997'>
No components of SQL found on this computer that qualifies for this package.
<EndFunc Name='SQLHotfix' Return='1168' GetLastError='997'><EndFunc Name='Ha
ndlePackage' Return='1168' GetLastError='997'>
=== Completed processing package defined in Hotfix2.inf with return code: 11
68
=== Of the 2 packages no package qualified to run on this computer
<EndFunc Name='ProcessPackages' Return='1168' GetLastError='1813'><EndFunc N
ame='WinMain' Return='1168' GetLastError='1813'>|||Run the following command and post the results.
OSQL -E -Q"select @.@.version"
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Here is the output from the command. Thanks, John
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copy
right (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows N
T 5.0 (Build 2195: Service Pack 3)|||Review the following registry keys on your machine.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersion
\CSDVersion
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersion
\CSDVersionNumber
They should look like this:
CSDVersion (string) 8.00.761
CSDVersionNumber (dword) 300 (hex)
Update these keys as needed, and retry applying the Security Update.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)