none
sql server 2008 R2 express in Windows 8

    Question

  • Can i install sql server 2008 R2 express(http://www.microsoft.com/en-us/download/details.aspx?id=3743) in a Windows 8 PC without enabling the .net 3.5 feature?
    Wednesday, February 20, 2013 6:30 AM

Answers

  • Hello,

    As per the MSDN article: hardware and software requirements for installation of SQL 2008 r2:

    http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx#SSE_x64

    Installing .NET Framework 2.0 SP2: .NET Framework 2.0 SP2 is not available as a separate download. You will need to install .NET Framework 3.5 SP1 which includes .NET Framework 2.0 SP2.

    SQL Server Setup will not install the following required components for SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services. You must install these components manually before you run SQL Server Setup:

    • SQL Server Express — .NET Framework 2.0 SP2 and Windows installer 4.5. On Windows Vista SP2, use .NET Framework 3.5 SP1.

    • SQL Server Express with Advanced Services — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.

    • SQL Server Express with Tools — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.

    Wednesday, February 20, 2013 10:20 AM
  • Hello,

    • As per: http://msdn.microsoft.com/en-us/library/bb822049.aspx

      The .NET Framework versions 2.0, 3.0, and 3.5 are built with the same version of the CLR (CLR 2.0). These versions represent successive layers of a single installation. Each version is built incrementally on top of the earlier .NET Framework versions. It is not possible to run versions 2.0, 3.0, and 3.5 side by side on a computer. When you install the .NET Framework 3.5 SP1, you get the 2.0 and 3.0 layers automatically. However, the .NET Framework 4.0 ends this layering approach. Starting with the .NET Framework 4, you can use in-process side-by-side hosting to run multiple versions of the CLR in a single process. Apps that were built for versions 2.0, 3.0, and 3.5 can all run on version 3.5, but they will not work on version 4 or later.

    Wednesday, February 20, 2013 3:14 PM
  • Hello Don,

    It is possible that i am going wrong ( i have just jumped from Windows XP to Windows 7 , Windows 8 is too young ...) but i think that Windows 8 is provided with .Net Framework 4.5

    http://msdn.microsoft.com/en-us/library/windows/desktop/hh848079(v=vs.85).aspx

    ".NET Framework 4.5 is enabled by default in Windows 8. Windows 8 does not include .NET 3.5 by default, but the files for .NET 3.5 are available on the Windows 8 installation media as an optional feature.

    If the user is upgrading from Windows 7 to Windows 8, .NET Framework 3.5 is fully enabled to ensure that any apps on the computer continue to work correctly."

    with http://msdn.microsoft.com/en-us/library/5a4x27ek.aspx , i have found :

    "The .NET Framework 4.5 replaces the .NET Framework 4. When you install the .NET Framework 4.5 on a system that has the .NET Framework 4 installed, the assemblies are replaced"

    I think that the problem .Net Framework 4.0 or 4.5 is not a problem.

    I have installed .Net 4.5 on my Windows 7 as i needed it for the install of Visual Studio 2012.And i have had no problem to install SQL Server Express 2012 which needs officially 4.0

    Windows has no official .Net Framework 4.0 only 4.5 which replaces the "old" 4.0.

    But , if the original poster wants to use SMO in his/her application, it is the full version of the 4.5 which should be installed ( with SDK and so on )

    Have a nice day

    PS : Windows 8 is provided with PowerShell 2.0 not 1.0 but SQL Server 2008 R2 supports the version 2.0 of PowerShell ( the 3.0 for PowerShell seems to be only in CTP from several months )


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.


    Wednesday, February 20, 2013 9:27 PM

All replies

  • Hello,

    Please, could you have a look at http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/1b193841-c8c9-4c0f-9fba-a249419540b7 ?

    It seems that you need the .Net Framework 3.5 or 4.0

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Wednesday, February 20, 2013 9:11 AM
  • Hello,

    As per the MSDN article: hardware and software requirements for installation of SQL 2008 r2:

    http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx#SSE_x64

    Installing .NET Framework 2.0 SP2: .NET Framework 2.0 SP2 is not available as a separate download. You will need to install .NET Framework 3.5 SP1 which includes .NET Framework 2.0 SP2.

    SQL Server Setup will not install the following required components for SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services. You must install these components manually before you run SQL Server Setup:

    • SQL Server Express — .NET Framework 2.0 SP2 and Windows installer 4.5. On Windows Vista SP2, use .NET Framework 3.5 SP1.

    • SQL Server Express with Advanced Services — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.

    • SQL Server Express with Tools — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.

    Wednesday, February 20, 2013 10:20 AM
  • But according to download link http://www.microsoft.com/en-us/download/details.aspx?id=3743 system requirement is "Step 1: Download and install Microsoft .Net Framework 3.5 SP1. or Download and install Microsoft .Net Framework 4.0."

    So i think it should work in windows 8 without enabling the .net 3.5

    Wednesday, February 20, 2013 2:44 PM
  • Hello,

    • As per: http://msdn.microsoft.com/en-us/library/bb822049.aspx

      The .NET Framework versions 2.0, 3.0, and 3.5 are built with the same version of the CLR (CLR 2.0). These versions represent successive layers of a single installation. Each version is built incrementally on top of the earlier .NET Framework versions. It is not possible to run versions 2.0, 3.0, and 3.5 side by side on a computer. When you install the .NET Framework 3.5 SP1, you get the 2.0 and 3.0 layers automatically. However, the .NET Framework 4.0 ends this layering approach. Starting with the .NET Framework 4, you can use in-process side-by-side hosting to run multiple versions of the CLR in a single process. Apps that were built for versions 2.0, 3.0, and 3.5 can all run on version 3.5, but they will not work on version 4 or later.

    Wednesday, February 20, 2013 3:14 PM
  • Hello Don,

    It is possible that i am going wrong ( i have just jumped from Windows XP to Windows 7 , Windows 8 is too young ...) but i think that Windows 8 is provided with .Net Framework 4.5

    http://msdn.microsoft.com/en-us/library/windows/desktop/hh848079(v=vs.85).aspx

    ".NET Framework 4.5 is enabled by default in Windows 8. Windows 8 does not include .NET 3.5 by default, but the files for .NET 3.5 are available on the Windows 8 installation media as an optional feature.

    If the user is upgrading from Windows 7 to Windows 8, .NET Framework 3.5 is fully enabled to ensure that any apps on the computer continue to work correctly."

    with http://msdn.microsoft.com/en-us/library/5a4x27ek.aspx , i have found :

    "The .NET Framework 4.5 replaces the .NET Framework 4. When you install the .NET Framework 4.5 on a system that has the .NET Framework 4 installed, the assemblies are replaced"

    I think that the problem .Net Framework 4.0 or 4.5 is not a problem.

    I have installed .Net 4.5 on my Windows 7 as i needed it for the install of Visual Studio 2012.And i have had no problem to install SQL Server Express 2012 which needs officially 4.0

    Windows has no official .Net Framework 4.0 only 4.5 which replaces the "old" 4.0.

    But , if the original poster wants to use SMO in his/her application, it is the full version of the 4.5 which should be installed ( with SDK and so on )

    Have a nice day

    PS : Windows 8 is provided with PowerShell 2.0 not 1.0 but SQL Server 2008 R2 supports the version 2.0 of PowerShell ( the 3.0 for PowerShell seems to be only in CTP from several months )


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.


    Wednesday, February 20, 2013 9:27 PM