As of SQL Server 2012 the .NET Framework prerequisite of .NET 3.5 SP1 is no longer installed for you by the SQL Server installer if it is found to be missing from the server. Now with Window Server 2008 R2 SP1 or higher this is simply enabling the feature within Windows Server, no actual installation. This can be easily accomplished with PowerShell as a quick script to run prior to doing the installation of SQL Server.
The PowerShell Windows cmdlet that is used in this instance will be:
The .NET 3.5 SP1 feature in Windows Server is referenced as
Net-Framework-Core in PowerShell. You can find this by calling the command:
The below script is going first verify it is not installed and then will enable the feature (or technically install it I guess). In order to do this though you will need the OS media as you have to pass in the source path to
<drive letter>:\sources\sxs. Note: You have to execute this in an elevated PowerShell console, so “Run as Administrator”.
#verify installed first (Get-WindowsFeature Net-Framework-Core).Installed #Add feature Install-WindowsFeature Net-Framework-Core -source 'G:\sources\sxs'
When you run this command you will see a status “bar” of sorts appear while it is performing the installation. Once completed you should see output that lets you know it was successful.
Now if you happen to see any errors you might reference the KB 2734782 - .NET Framework 3.5 installation error as there are various reasons why this command might fail.
A small update to this post…
I recently came across a server that I was getting the
0x800f0906 error and went through the article above verifying Internet access from the server and having mounted the ISO for the OS properly. I came across a blog post that brings up the possibility that you need to update the local source media on the server.