November 6, 2009 at 6:28 am
Hi Folks,
I did an install of service pack 3 for sql server 2005. It came back as successful but when I check in management studio it shows as the sp2 version. I also checked patchlevel in registry editor and it shows the sp2 version (3042).
What the heck am I doing wrong? My account is part of the administrators group.
If anyone knows anything I would appreciate as this is driving me crazy.
Thanks
Troy
November 6, 2009 at 7:42 pm
Troy,
To get the definitive server version information, run the following:
SELECT SERVERPROPERTY('productversion'),
SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')
If that confirms the SP2 level, re-run the SP3 installation, being extra careful to ensure you are upgrading the correct instance, and examine each screen carefully to look for error messages. It is quite common for the upgrade tool to look as if it succeeded at the end when in fact a failure occurred :blink:
The tool should also show you the state of the current installation, and whether each component requires updating or not. Don't forget to patch your client tools also.
Paul
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply