locked
Install App that uses .NET Framework 4 and SQL Server 2008R2 Express (with Tools) - what .NET Frameworks are needed? RRS feed

  • Question

  • I am a little confused about how to install my application.  Written in C# using VS 2010 and targeted for the .NET 4 Framework.  It also uses a SQL Server 2008 R2 database.

    In my installer I install .NET 4 Framework if not already present on the host machine.

    For SQL Server 2008 R2 (with Tools) I understood I need Installer 4.5 and Powershell 1.0.  The install of install of 4.5 installer goes ok but requires a reboot.  The install of Powershell says it needs .NET Framework 2 SP2 - even tho' .NET 4 is installed.

    I decide to ignore this and carry on so manually install SQL Server 2008 R2 Express (with Tools).  It unpacks and complains it needs .NET Framework 3.5 SP1!

    My application has to deploy to a disconnected machine installed in the cab of a logging harvester so I can't rely on automatic wwindows updates.

     

    To deploy my app with SQL Server 2008 R2 (with Tools) do I need ...

    • .NET Framework 2.0 SP2 and
    • .NET Framework 3.5 SP1 and
    • .NET Framework 4

    ??

    Wow??

    I had presumed all I would would be .NET Framework 4 since it is "mostly" backwardly compatible.

    Install time and complexity is HUGE is I need all three Frameworks.

     

    Can someone please clarify for me?

    Thanks

     

    John.

     

     

     

     

    Wednesday, September 22, 2010 10:14 AM

Answers

  • Hi,

    Thanks Andrea for your clarification, now we get from that blog post:

    ·         SQL Server 2008 Express supports .NET Framework 2.0 SP2 or .NET Framework 3.5 SP1; however .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. More information at here.

    ·         New release of SQL Server 2008 Express SP1 or SQL Server 2008 Express R2 RTM supports .NET Framework 3.5 SP1 or .NET Framework 4.0.

    ·         Any edition of SQL Server 2008/2008 R2 Express with Tools or SQL Server 20008/2008 R2 Express with Advanced Services only supports .NET Framework 3.5 SP1.

    To download new release of SQL Server 2008 Express SP1 that supports .NET Framework 4.0, please see Instructions -> Audiences section at Microsoft SQL Server 2008 Express SP1.

    Please let us know if you have more information.

    Thanks,

    • Marked as answer by Tom Li - MSFT Friday, October 1, 2010 9:30 AM
    Friday, September 24, 2010 1:57 AM

All replies

  • Hi.

    You need the following for distribute SQL 2008 R2.

    .NET Framework 3.5 SP1

    Powershell v2

    Windows installer 4.5

     


    Kristian
    Wednesday, September 22, 2010 12:19 PM
  • Hi.

    You need the following for distribute SQL 2008 R2.

    .NET Framework 3.5 SP1

    Powershell v2

    Windows installer 4.5

     


    Kristian

     

    Thanks for the reply Kristian.  I'm still a little confused tho'.

    The download page for SQL Server 2008 R2 Express RTM here...

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8B3695D9-415E-41F0-A079-25AB0412424B

    says

    Step 1: Download and install Microsoft .Net Framework 3.5 SP1. or Download and install Microsoft .Net Framework 4.0.
    Step 2: Download and install Windows Installer 4.5.
    Step 3: Download SQL Server 2008 R2 Express by clicking the appropriate link below.

     

    So it sounds like 4.0 is an option if I don't want to have to install 3.5 SP1 as well.  I realise this is the option without the Tools.  For Tools I also need Powershell (which demands  .NET 2.0 SP2).

    Interestingly(?) the download page with Tools here...

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=967225eb-207b-4950-91df-eeb5f35a80ee&displaylang=en

    says

    Step 1: Download and install Microsoft .Net Framework 3.5 SP1.
    Step 2: Download and install Windows Installer 4.5.
    Step 3: Download and install Windows PowerShell 1.0.
    Step 4: Download SQL Server 2008 R2 Express with Management Tools by clicking the appropriate link below.

     

    No mention of .NET 4.0.  Maybe it's the Tools option that requires 3.5SP1?

    I'm loathed t have to install the 240Mb worth of .NET 3.5 SP1 prior to installing the 50Mb of .NET 4.

     

    John

     

     

    Wednesday, September 22, 2010 10:02 PM
  • Hi John,

    As far as I know, both SQL Server 2008 (Express) and SQL Server 2008 R2 (express) requires .NET Framework 3.5 with SP1 installed before installing. Windows 7 or Windows Server 2008 R2 ships .NET Framework 3.5.1 (.NET Framework 3.5 with SP1) features, there is no need to install but require to turn .NET Framework 3.5.1 on.

    Hope this helps.

    Thanks,
    Chunsong


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, September 23, 2010 11:25 AM
  • hi Chunsong,

    SQLExpress 2008 sp1 was available with "net4" only requirements as indicated in http://blogs.msdn.com/b/sqlexpress/archive/2009/12/09/sql-server-express-and-net-4.aspx..

    I did not test it myself, but I do suppose the package only provides the Relational Engine without tools as it is only sized 95mb for the x86 version.. plans for R2 as well? :)

    thank you


    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools http://www.hotelsole.com/ - http://www.hotelsolericcione.de
    Thursday, September 23, 2010 11:19 PM
  • Hi,

    Thanks Andrea for your clarification, now we get from that blog post:

    ·         SQL Server 2008 Express supports .NET Framework 2.0 SP2 or .NET Framework 3.5 SP1; however .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. More information at here.

    ·         New release of SQL Server 2008 Express SP1 or SQL Server 2008 Express R2 RTM supports .NET Framework 3.5 SP1 or .NET Framework 4.0.

    ·         Any edition of SQL Server 2008/2008 R2 Express with Tools or SQL Server 20008/2008 R2 Express with Advanced Services only supports .NET Framework 3.5 SP1.

    To download new release of SQL Server 2008 Express SP1 that supports .NET Framework 4.0, please see Instructions -> Audiences section at Microsoft SQL Server 2008 Express SP1.

    Please let us know if you have more information.

    Thanks,

    • Marked as answer by Tom Li - MSFT Friday, October 1, 2010 9:30 AM
    Friday, September 24, 2010 1:57 AM