SQL Server Performance

Installing SQL 2008 Express on 64-bit platform...

Discussion in 'SQL Server 2008 General Developer Questions' started by gcetti, Oct 18, 2010.

  1. gcetti New Member

    I have a couple of questions regarding which version of SQL Express 2008 we should install for our 32-bit application.
    1) Can the SQL Express 32-bit installation (silent install needed) be installed to a 64-bit operating system, or of the SQL Express 2008 downloads available, does the 32 have to be installed on a 32-bit system and 64 has to be installed on 64-bit system?
    2) Our application is a 32-bit app that can run on a 64-bit operating system, but is there any advantage (or compatibility issues) with running the 64-bit version of SQL Express 2008?
    Thanks for any help,
    Greg
    gcetti, Oct 18, 2010
    #2

  2. Luis Martin Moderator

    1) You can install SQL 32 on 64x OS. Viceversa is not possible.2) There is advantages, but is compatible. No problem.
    Luis Martin, Oct 18, 2010
    #3

  3. gcetti New Member

    I'm running into problems trying to install the SQL Express 2008 (32 bit) image on a 64-bit operating system (Windows Server 2003 SP2) - I get the following error message:
    Rule "Edition WOW 64 platform" failed.
    SQL Server Setup is not supported in WOW64. This setup program can only be run on a 32-bit system.
    I am running the SQLExpr32_x86_enu I downloaded from Microsoft. Is there a parameter or something I need to make this work?
    Thanks,
    Greg
    gcetti, Oct 19, 2010
    #4

  4. Luis Martin Moderator

    SQL Server 2008 Standard (32-bit) is supported on the following operating systems:
    (Look at note 1 at the bottom)


    Windows XP Professional SP2
    Windows XP SP2 Tablet
    Windows XP x64 Professional1
    Windows XP SP2 Media Center 2002
    Windows XP SP2 Media Center 2004
    Windows XP Media Center 2005
    Windows XP Professional Reduced Media
    Windows Server 2003 SP2 Small Business Server R2 Standard
    Windows Server 2003 SP2 Small Business Server R2 Premium
    Windows Server 2003 SP2 Standard
    Windows Server 2003 SP2 Enterprise
    Windows Server 2003 SP2 Datacenter
    Windows Server 2003 SP2 Small Business Server Standard
    Windows Server 2003 SP2 Small Business Server Premium
    Windows Server 2003 SP2 64-bit x64 Standard1
    Windows Server 2003 SP2 64-bit x64 Datacenter1
    Windows Server 2003 SP2 64-bit x64 Enterprise1
    Windows Vista Ultimate
    Windows Vista Enterprise
    Windows Vista Business
    Windows Vista Ultimate x641
    Windows Vista Enterprise x641
    Windows Vista Business x641
    Windows Server 2008 Web
    Windows Server 2008 Standard Server
    Windows Server 2008 Standard Server without Hyper-V
    Windows Server 2008 Datacenter
    Windows Server 2008 Datacenter without Hyper-V
    Windows Server 2008 Enterprise
    Windows Server 2008 Enterprise without Hyper-V
    Windows Server 2008 x64 Standard
    Windows Server 2008 x64 Standard without Hyper-V1
    Windows Server 2008 x64 Datacenter
    Windows Server 2008 x64 Datacenter without Hyper-V1
    Windows Server 2008 x64 Enterprise
    Windows Server 2008 x64 Enterprise without Hyper-V1
    Windows Small Business Server 20082
    Windows Server 2008 for Windows Essential Server Solutions2
    Windows Server 2008 without Hyper-V for Windows Essential Server Solutions2
    Windows 7 Ultimate3
    Windows 7 Enterprise3
    Windows 7 Professional3
    Windows 7 64-bit x64 Ultimate1,3
    Windows 7 64-bit x64 Enterprise1,3
    Windows 7 64-bit x64 Professional1,3
    Windows Server 2008 R2 64-bit x64 Web1,3
    Windows Server 2008 R2 Foundation Server1,3
    Windows Server 2008 R2 64-bit x64 Standard1,3
    Windows Server 2008 R2 64-bit x64 Enterprise1,3
    Windows Server 2008 R2 64-bit x64 Datacenter1,3

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

    1This edition of SQL Server can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations.
    2Supported Operating Systems for SQL Server Standard for Small Business
    3Supported only on SQL Server SP1 or higher.
    Luis Martin, Oct 19, 2010
    #5

  5. charlii New Member

    Thanks for the solution SQL 2008 it really works.
    charlii, Oct 22, 2010
    #6

Share This Page