okcuser
asked on
SQL 2000 sp4 applied, but still shows sp3
I too am trying to install SQL 2000 sp4 on 2003 server (sp2).
On the server, opening enterprise manager, I right click on Local database and select properties
console root
-->ms sql servers
---->sql server group
------>local
It shows product version 8.00.818 (SP3)
I have applied SQL 2000 sp4 multiple times w/o error (although it does seem to go quickly). I've tried running it with the serice stopped, after rebooting, rebooting after, etc with no luck. Still shows sp3.
In ms kb article 321185 I found notes to check the versions
SELECT SERVERPROPERTY('productver sion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
(run on master of local database instance)
returns
8.00.818 SP3 Standard Edition
KB also said to check version of Sqlservr.exe file on server.
Search shows
c:\mssql7\binn\sqlservr.ex e (version 2000.80.818.0)
c:\sql2ksp4\x86\binn\sqlse rvr.exe (version 2000.80.2039.0)
c:\mssql7\x86\binn\sqlserv r.exe (version 2000.80.2039.0)
according to the kb .2039 is sp4 and the other is a form of sp3 with a patch installed.
I'm assuming that when I apply the sp4 it is not applying it to the right location. The default when prompted is the
c:\sql2ksp4. I ran it a second time and changed it to use c:\mssql7. Still isn't showing correctly.
Please help me figure out how to apply sp4 correctly show it shows as applied. I thought this was done a long time ago until a security audit flagged it as a risk.
Thanks!
On the server, opening enterprise manager, I right click on Local database and select properties
console root
-->ms sql servers
---->sql server group
------>local
It shows product version 8.00.818 (SP3)
I have applied SQL 2000 sp4 multiple times w/o error (although it does seem to go quickly). I've tried running it with the serice stopped, after rebooting, rebooting after, etc with no luck. Still shows sp3.
In ms kb article 321185 I found notes to check the versions
SELECT SERVERPROPERTY('productver
(run on master of local database instance)
returns
8.00.818 SP3 Standard Edition
KB also said to check version of Sqlservr.exe file on server.
Search shows
c:\mssql7\binn\sqlservr.ex
c:\sql2ksp4\x86\binn\sqlse
c:\mssql7\x86\binn\sqlserv
according to the kb .2039 is sp4 and the other is a form of sp3 with a patch installed.
I'm assuming that when I apply the sp4 it is not applying it to the right location. The default when prompted is the
c:\sql2ksp4. I ran it a second time and changed it to use c:\mssql7. Still isn't showing correctly.
Please help me figure out how to apply sp4 correctly show it shows as applied. I thought this was done a long time ago until a security audit flagged it as a risk.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER