SQL 2005 SP3 Installed - Still shows SP2

Question

SQL 2005 SP3 Installed - Still shows SP2

Leo.Miller

SSChampion

Points: 13051
More actions
September 1, 2011 at 2:53 pm

#243136

We installed SP3 on both nodes of a cluster, with all the relevant restarts etc.
@@VERSION and SERVERPROPERTY show the version is still 9.00.3042 (SP2).
The SQLServr.exe properties/version and SSMS Help About both show version 4035 (SP3).
The registry entry SOFTWARE\Microsoft\Microsoft SQLServer\MSSQL.1\MSSQLServer\CurrentVersion shows 9.00.4035.0 as expected.
The registry entry SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion however still shows 9.00.3042.0.
The install logs show no errors besides 3010 for SQLServer and SQLAgent which indicates a restart is needed, which was done.
There don't appear to be any issues with the server, everything is working fine, it's just worrying that we may have missed something.
Has any one seen this before? Any ideas why it may happen and what can be done to fix it. A reinstall is currently out of the question.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Looks like just the tools upgraded and not the database engine.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Leo.Miller SSChampion Points: 13051 More actions · Answer 2

SQLRNNR (9/1/2011)
Looks like just the tools upgraded and not the database engine.

More likely the other way around since sqlservr.exe version shows 4035.

Leo

Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

SSMS Help/about is the version of the tools.

But I also missed the part about sqlserver.exe

I'd treat it as a failed upgrade.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events