Post reply

Update SQL/Server 2005 SP2 to SP3 Fails

  • December 17, 2009 at 6:01 pm

    #136860

    I have a single instance of SQL/Server 2005 Standard Edition (sp2) running on a Window Server 2003 SP2 server. I am trying to apply the SP3 cumulative patch bundle to my instance but I am not given the option to upgrade SQL / Server.

    After starting the upgrade, you will get the Feature Selection page. When I attempt to check the MSSQLSERVER, I am not able to. It appears the box is disabled. When I attempt to check Database Services, the same thing happen. However, I do get a bit more information. In the Status window, the value displayed is "Not Valid". In the Details window, the value "The product instance MSSQLSERVER been patched with more recent updates".

    I am not sure what is preventing me from updating SQL/Server.

    Any thoughts?

    Thanks.

    Steve

  • December 17, 2009 at 7:57 pm

    #1093853

    In the Query Editor, run the following command and post what the resultset is.

    SELECT SERVERPROPERTY ('productlevel')

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 17, 2009 at 9:20 pm

    #1093861

    Before posting my original message, I did a SELECT @@VERSION which presented misleading information (which made me think I was running SP2).

    'ProductLevel' returned SP3. I must have run the SP3 update sometime ago...

    Thanks for the reply.

  • December 17, 2009 at 9:51 pm

    #1093865

    Yes that must have been the case..

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

Viewing 4 posts - 1 through 4 (of 4 total)

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