Cannot update MSSQL2008 to SP2

  • I have install MSSQL2008 (incl. SP1) on a Win2008 R2 Standard server.

    But when I try to install SQL 2008 SP2 I can only select the Shared Features.

    Can anyone help me with this ?

    Or can tell me what I do wrong ?

    Thanx

  • Hi

    Make sure you have the right install 32 bit or 64 bit , it will not upgrade the engine if you do not have the correct Bit

  • Run this to get environment type:

    [font="Courier New"]USE master;

    GO

    SELECT @@VERSION;

    GO[/font]

    As explained above if your existing SQL 2008 installation is a X64 then you need X64 related SP2 files and similarly for X86 too.

    -Satya SK Jayanty
    SQL Server MVP (Follow me @sqlmaster)
    Author of SQL Server 2008 R2 Administration CookBook
    SQL Server Knowledge Sharing network

  • Thanx ! 32 / 64 bit was the keyword !

    I Thought I uses 32 bit, but it turned to be 64 bit.

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

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