| Author |
Topic |
|
simetra
Starting Member
7 Posts |
 Posted - 2009-08-24 : 12:59:02
|
| SP3 installs without any errors, however, the version of SQL server is still 9.00.3042 when it should be 9.00.4035. I looked at the properties for sqlservr.exe and the version is 2005.90.3042.0. It doesn't seem to be upgrading to the latest SP. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-24 : 13:22:14
|
| Did you Restart SQL Server and other related services? |
 |
|
|
simetra
Starting Member
7 Posts |
Posted - 2009-08-24 : 13:51:19
|
| Yes, Rebooted the server after installation. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-24 : 13:53:42
|
what does this return?SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-24 : 13:54:28
|
| sure you are looking at the right server? looked in windows event logs? |
|
|
|
simetra
Starting Member
7 Posts |
Posted - 2009-08-24 : 14:16:36
|
| Query Result:9.00.3042.00 SP2 Standard EditionEvent Viewer:No errors just the following events which were all successful.Product: Microsoft SQL Server Setup Support Files (English) -- Configuration completed successfully.Product: Microsoft SQL Server Native Client -- Configuration completed successfullyProduct: MSXML 6.0 Parser -- Installation completed successfully.Product: SQLXML4 -- Configuration completed successfully.Product: Microsoft SQL Server VSS Writer -- Configuration completed successfully. |
|
|
|
simetra
Starting Member
7 Posts |
Posted - 2009-08-24 : 14:24:18
|
| I just try to runSecurity Update for SQL Server 2005 Service Pack 2 (KB954606)and get this error:This machine does not have a product that matches this installation package.Think this problem is related? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-24 : 14:54:06
|
| yes. try rerunning SP3 install. seems it never completed |
|
|
|
simetra
Starting Member
7 Posts |
Posted - 2009-08-24 : 15:23:15
|
| Reinstalled and rebooted with the same result. No errors displayed or recored in Event Viewer. |
|
|
|
simetra
Starting Member
7 Posts |
Posted - 2009-08-24 : 17:15:07
|
| Figured out the problem. It seems that the WMI was messed up. So I ran rundll32 wbemupgd, RepairWMISetupand this fixed that problem. Next, I repaired SQL server by runningsetup.exe REINSTALL=ALL REINSTALDATABASE=1 REINSTALLMODE=omus Rebooted and was able to apply SP3 no problem.Thanks. |
|
|
|
DeepGround
Yak Posting Veteran
73 Posts |
Posted - 2009-08-28 : 13:59:55
|
| I have the same problem, how in the world can you install a software update, have it run though all this installation tasks and then nothing changes, first time I have ever seen this with even free software little yet mutli thousand dollar softwre.... I am begining not to like sql 2005... |
|
|
|
DeepGround
Yak Posting Veteran
73 Posts |
Posted - 2009-08-28 : 14:01:34
|
quote:
Originally posted by simetra
Figured out the problem. It seems that the WMI was messed up. So I ran rundll32 wbemupgd, RepairWMISetup
I get an error when I run that command |
|
|
|
|
Installing SP3