Post reply

Upgrate to SQL2005 SP3 not working

  • May 18, 2009 at 10:52 am

    #131680

    Hi,

    I am trying to upgrade to SQL 2005 Standard 64b from version

    "Microsoft SQL Server 2005 - 9.00.3282.00 (X64) Aug 5 2008 00:48:00 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)"

    This problem is I can't select MSSQLSERVER form the Feature Selection in the Service Pack 3 setup window. What do I need to do to be able to select it?

    I already did some other upgrade without any problem.

    Thanks for your help...

  • May 18, 2009 at 11:38 am

    #996527

    Already What upgrade you did on that server?

    Can you be more clear on question.

    Applied Sp2 also??


    - Pradyothana     http://www.msqlserver.com

  • May 18, 2009 at 12:19 pm

    #996551

    Ok, I was finally able to run the upgrade. I was going from SP2 (cu#9) to SP3.

    Now my version is:

    Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    The build is OK ' 9.00.4035' but why I am still seeing 'Service Pack 2'? This seems to be strange, no?

    Thanks

  • May 18, 2009 at 12:28 pm

    #996558

    You will be on SP3 if its sucessfull intalation.

    Fire the the following on query window

    select serverproperty('ProductLevel ')

    --------------------

    I hope the service pack 2 which is there is of OS.

    ---------------------


    - Pradyothana     http://www.msqlserver.com

  • May 18, 2009 at 12:35 pm

    #996563

    Rem (5/18/2009)

    Ok, I was finally able to run the upgrade. I was going from SP2 (cu#9) to SP3.

    Now my version is:

    Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    The build is OK ' 9.00.4035' but why I am still seeing 'Service Pack 2'? This seems to be strange, no?

    Thanks

    That's the Windows Service Pack

    [font="Verdana"]Markus Bohse[/font]

  • May 18, 2009 at 1:09 pm

    #996575

    Result: SP3

    Am I OK?

  • May 18, 2009 at 2:11 pm

    #996622

    Rem (5/18/2009)

    Result: SP3

    Am I OK?

    Simple answer. Yes.

    Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) -- This bolded part is refering to the Service Pack level of the Operating System, NOT SQL Server.

  • May 18, 2009 at 2:30 pm

    #996631

    YUp,

    You are on SP3


    - Pradyothana     http://www.msqlserver.com

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

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