none
SQL 2008 (32 bit) on Windows 2008 R2 (64 bit)

    Question

  • Experts,

    While installtion on SQL Server 2008 (32bit) on Windows 2008 R2 (64bit), it gives a message like ".Net Framework 3.5 is required to install SQL". Tried to install . NET framework 3.5, 3.5 SP1 and 4 on the Windows 2008 R2 System, but no luck. Is this the problem with compatibility of 32 bit SQL on 64 bit OS?

    Is SQL Server 2008 32 bit version installation compatible with Windows 2008 R2 64 bit?

    Thanks

    Shiva

    Tuesday, October 05, 2010 5:26 AM

Answers

  • Hi SivaKumarR,

     

    SQL Server 2008 32 bit version can be installed on Windows 2008 R2 64 bit Operating System, it could be installed under folder <Driver>:/Program Files (X86) by default. SIVA had already made a good answer about this question.

     

    According to the error message, one possible cause could be that the.Net Framework 3.5 SP1 is a beta version, Would you please kindly check if it is a beta version? we can find it at Programs and Features of the Control Panel.

     

    If this is the case, as a possible workaround, we need to remove it and install.Net Framework 3.5 SP1 formal version. As far as I know, Windows Server 2008 R2 includes .Net Framework 3.5 with SP1. We need to install it from --> Server Manager --> Features --> .Net Framework 3.5.1 Features.       

     

    After the installation, we can verify it via the following registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP

    Also, would you please take a look at the following link from Pearl, this could be one possible workaround too.

    http://www.sqlservercentral.com/blogs/pearlknows/archive/2010/07/19/sql-server-2008-installation-on-windows-7-help-is-finally-here.aspx

     

    Besides, if the problem is still there, would you please collect the error messages logged into the setup log files summary.txt which are located in the %Program files%\Microsoft SQL Server\100\Setup bootstrap\Log\ folder. This will help us to troubleshoot the issue.

     

    For more information about how to View and Read SQL Server Setup Log Files, please see http://msdn.microsoft.com/en-us/library/ms143702.aspx

     

    If there are more questions, please feel free to ask.

     

    Thanks,

    Grace


    Please kindly mark the answer if it is a workaround. Thanks a lot *^_^*
    Wednesday, October 06, 2010 8:46 AM

All replies

  • SQL Server 2008 32 bit edition compatible with Windows 2008 R2 64 bit.

    WOW64, a feature of 64-bit editions of Windows that enables 32-bit applications to run natively in 32-bit mode. Applications function in 32-bit mode, even though the underlying operating system is running on the 64-bit operating system. WOW64 is supported only for stand-alone instances of SQL Server, WOW64 is not supported for SQL Server failover cluster installations.

    On a supported 64-bit operating system, SQL Server 32-bit Edition installations can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server.

    Source: Hardware and Software Requirements for Installing SQL Server 2008 R2


    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    Tuesday, October 05, 2010 5:55 AM
  • Thanks Siva,

    When i try to install SQL Server 32 bit on Windows 2008 64 bit, it gives a message like ".Net Framework 3.5 is required to install SQL". I tried to install . NET framework 3.5, 3.5 SP1 and 4 on the Windows 2008 R2 System, but no luck.

    Tuesday, October 05, 2010 5:59 AM
  • Did you try installing .net from Server Management > Features > .NET 3.5.1 Features ? If so - what was the exact error you got?

    Tuesday, October 05, 2010 7:42 AM
  • Perhaps it is the 32 bit framework which is needed? Just a wild guess, but might be worth searching the net for...
    Tibor Karaszi, SQL Server MVP | web | blog
    Tuesday, October 05, 2010 7:56 AM
  • SivakumarR,

    See if this link helps you http://blogs.msdn.com/b/psssql/archive/2008/08/11/sql-server-2008-visual-studio-2008-sp1-and-net-framework-3-5-sp1-explained.aspx


    Hemantgiri S. Goswami | SQL Server Citation | http://www.surat-user-group.org/ -- Surat SQL Server User Group
    Tuesday, October 05, 2010 11:16 AM
  • Hi SivaKumarR,

     

    SQL Server 2008 32 bit version can be installed on Windows 2008 R2 64 bit Operating System, it could be installed under folder <Driver>:/Program Files (X86) by default. SIVA had already made a good answer about this question.

     

    According to the error message, one possible cause could be that the.Net Framework 3.5 SP1 is a beta version, Would you please kindly check if it is a beta version? we can find it at Programs and Features of the Control Panel.

     

    If this is the case, as a possible workaround, we need to remove it and install.Net Framework 3.5 SP1 formal version. As far as I know, Windows Server 2008 R2 includes .Net Framework 3.5 with SP1. We need to install it from --> Server Manager --> Features --> .Net Framework 3.5.1 Features.       

     

    After the installation, we can verify it via the following registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP

    Also, would you please take a look at the following link from Pearl, this could be one possible workaround too.

    http://www.sqlservercentral.com/blogs/pearlknows/archive/2010/07/19/sql-server-2008-installation-on-windows-7-help-is-finally-here.aspx

     

    Besides, if the problem is still there, would you please collect the error messages logged into the setup log files summary.txt which are located in the %Program files%\Microsoft SQL Server\100\Setup bootstrap\Log\ folder. This will help us to troubleshoot the issue.

     

    For more information about how to View and Read SQL Server Setup Log Files, please see http://msdn.microsoft.com/en-us/library/ms143702.aspx

     

    If there are more questions, please feel free to ask.

     

    Thanks,

    Grace


    Please kindly mark the answer if it is a workaround. Thanks a lot *^_^*
    Wednesday, October 06, 2010 8:46 AM