Post reply

SP2 for SQL Server 2005

  • February 21, 2007 at 7:57 am

    #117751

    Guys

    I have quick question, I am trying to install SQL Server 2005 SP 2. The server OS is Windows 2003 how will I know which

    ones to from below

    SQLServer2005SP2-KB921896-IA64-ENU.exe

    SQLServer2005SP2-KB921896-x64-ENU.exe

    SQLServer2005SP2-KB921896-x86-ENU.exe

    More specifically what bit is Windows 2003 and Win XP, how will I find the bit of a machine with Windows OS.

    Thanks

  • February 21, 2007 at 8:04 am

    #690915

    IA64 is if you have an Itanium 64 bit Machine and SQL Server

    x64 is if your running the normal 64 bit SQL Server

    X86 is for all others ( normal 32 bit SQL Server)

     

    Hope that this helps

    Eric

  • February 21, 2007 at 8:11 am

    #690921

    one last thing....

    To determine which one you have installed, click on the properties for your SQL Server instance, and look on the

    GENERAL Page

    >>>> Product : Microsoft SQL Server (Standard/Enterprise/Developer) Edition (64-Bit) 

    The 64 bit will only appear if your running a 64 bit SQL server.   If your running 32 bit there will not be anything following the "edition"

    EP

  • February 21, 2007 at 8:47 am

    #690935

    Thanks for the info Eric

    One more question is it safe to patch the SQL Server with SP2, or do we have to wait for any validation from Microsoft or any other agency.

    Thanks

  • February 21, 2007 at 9:38 am

    #690964

    i installed it on my PC and a reporting server that i set up for myself and is not production. For prod we are going to install it in QA and dev servers first and then prod once everything is OK

  • April 28, 2008 at 9:17 am

    #807875

    ..... one last thing....

    To determine which one you have installed, click on the properties for your SQL Server instance, and look on the

    GENERAL Page

    >>>> Product : Microsoft SQL Server (Standard/Enterprise/Developer) Edition (64-Bit)

    The 64 bit will only appear if your running a 64 bit SQL server. If your running 32 bit there will not be anything following the "edition"

    EP

    Question:

    If it's Itanium 64-bit then what would it say in

    Properties/general tab?

    Thanks,

    Rob

Viewing 6 posts - 1 through 5 (of 5 total)

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