Issues Installing SQL Server 2012 on Windows Server 2012

Jul 14, 2014

SQL Server 2012 requires that the .NET 3.5 Framework be installed for it to successfully install all of the client tools. Unfortunately, Windows Server 2012 does not install the .NET 3.5 Framework by default, but instead installs the .NET 4.5 Framework. You will get the message that your SQL Server 2012 installation failed on the management tools setup and that you need to install the .NET 3.5 Framework and run the setup again:

 

        

 

As luck would have it, installing the .NET 3.5 Framework on Windows Server 2012 is not exactly as straightforward as going into Server Manager > Manage > Add Roles and Features like it should be. You will see the following errors:

 
 

First you will get a warning about missing source files:

 
 


 
 

If you go in and specify an alternate source path that actually does have the files, say “g:\Sources\SxS”, and click the Install button, you will eventually get an error that says that the source files cannot be found.

 
 

In order to work around all of this funkiness with Windows Server 2012 and the .NET 3.5 Framework installation follow the steps below:

 
 

  1. First off, we need to get the source files for the .NET 3.5 Framework off of the Windows Server 2012 ISO.
    1. Mount up the Windows Server 2012 ISO
    2. Assuming that the mounted ISO has been given the drive letter of “G:” (change this in the command below to whatever the drive letter actually is in your particular case), run the following command to copy the .NET 3.5 Framework files to the C:\ drive.

 
 

xcopy g:\sources\sxs\*.* c:\dotnet35 /s

 
 

  1. Next, we need to go into the registry (regedt32.exe) and create a new key. Before you do anything in the registry, do a complete backup of the registry.
    1. Create the following key:

       
       

      HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\Servicing

       
       

    2. Under this key, create a REG_EXPAND_SZ entry named “LocalSourcePath” and give it a Value of “c:\dotnet35″ (remember, this is where we copied the .NET 3.5 Framework files earlier).
    3. Also under this key, create a DWORD32 entry named “RepairContentServerSource” and give it a value of 2.
  2. Go back to the Server Manager > Dashboard > Manage > Add Roles and Features and once again try to install the .NET 3.5 Framework. This time you should be met with success.

 
 

 
 

From here, you should be able to re-run the SQL Server 2012 setup again and choose the management tools install and the installation should progress without issue.

Posted by tbedwards | Categories: Administration |

Share with others

No Responses so far | Have Your Say!

Leave a Feedback

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Spam Protection by WP-SpamFree Plugin