Translate

March 04, 2014

Microsoft SQL server 2012 installation error while enabling NetFx3 OS feature in windows 8 or 8.1



Hello Buddy here is my next tutorial for you ,As we know in windows 8 or 8.1 ".Net framework 3.5(include 2.0 or 3.0)" is optional so it will not automatically enable during the windows installation but we need it to be enable to get OS feature called NetFx3 , Otherwise we will get Error while installing Microsoft SQL Server 2012 cause it will try to Enable NetFx3 while installation. So, Let's start with the tutorial to enable it by some easy steps ....


Here i am going to solve this problem by two way ,You can use which one is more suitable for you.

Solution First:

This is the first way you can enable .Net Framework 3.5(include 2.0 or 3.0) by a very simple steps and after that you can install your Microsoft SQL Server 2012 , It will install without error ,you will not have to enable NetFx3 Feature manually anywhere after these simple steps .So Let's start..
  1. Go to the search in charm and type Turn Windows features on or off and click over that.

  2. Now you will see a window opened on screen named Turn Windows Features on or off. As shown in the figure bellow .


    Figure 1: Turn Windows feature on or off window

  3. As you can see in the window an unchecked check box before the feature .Net Framework 3.5(include 2.0 or 3.0)

  4. Just check that check box and click Ok .

  5. Before that make sure you have Internet connection ,So. It will download some file to enable this feature in your computer .

  6. Now you have done enabling the Feature now restart your computer so it will work fine with your machine and now you are ready to install your Microsoft SQL Server 2012 in your machine , Now it will install fine without error related to NetFx3 OS feature .



Solution Second:

Here is one more way as i mention before starting the tutorial and here you go .this is also a very simple and most useful way to enable NetFx3 through command prompt using your windows installation media (CD or DVD). you have to do some vary simple work as mention in these steps below and most important here you do not need Internet connection at all .So let's start with the tutorial ....
  1. Run Command Prompt as administrator and now you can check with the OS Features what are enabled or disabled in your computer , For that you need to type a simple command in command prompt window as : C:\>dism /online /get-features .

  2. And here you can find the Feature called NetFx3 which is stated
    Feature Name : NetFx3
    State : Disabled with payload removed
    It means that .Net framework is not a part of current Operating System .

  3. So here you need to insert your OS CD or DVD into DVD Drive and you can find sxs folder in sources folder inside the OS DVD if you open it as shown in the figure below .


    Figure 2: sxs folder inside source in OS DVD.

  4. Now you need to write a simple DISM command in your command prompt running with administration privileges.
    command :
    C:\>dism /online /enable-feature /featurename:NetFx3 /All /Source:G:\sources\sxs /LimitAccess
    As shown in the Image below


    Figure 3: DISM COMMAND in command prompt

  5. Explanation about the command
    • DISM : Deployment Image Servicing and Management
    • /Online : targets the operating system you're running (instead of an offline Windows image( DVD)).
    • /Enable-Feature /FeatureName:NetFx3 : specifies that you want to enable the .NET Framework 3.5.
    • /All : enables all parent features of the .NET Framework 3.5.
    • /Source : specifies the location of the files needed to restore the feature (in this example, the G:\sources\sxs directory).
    • /LimitAccess : prevents DISM from contacting Windows Update.

  6. Now almost you done ! after 100% success of the command restart your computer so it will make changes in the features and will work fine .

  7. Now your computer enabled .Net Framework as you can see in the figure below .


    Figure 4: .Net Framework enabled

Now you can run your Microsoft SQL Server installation Disk so It will install fine without error regarding NetFx3 feature .

That's all you have to do. thanks ! and get connected for such information
All the best for your great future .


******