Tuesday, August 06, 2013

NetFx3 error on Windows Server 2012 installing SQL Server 2012

So I got a NetFx3 error on SQL Server 2012 installation saying that one or more windows features was not enabled. It was missing .net3.5 Windows Server 2012 comes with .net 4.5 but the SQL Server 2012 amazingly requires .net 3.5 (weird, cmon MSFT!). Anyway when I go to server manager in windows 2012 and try to add the legacy .net 3.5 feature, it failed. Therefor you have to run a command prompt as administrator and have access to the install files for your windows server 2012 and run this command (see screenshots below): The error during SQL Server install: Try to install from Windows Server 2012 Server Manager Console and still no dice: Try to install from command prompt (note the /all switch - it is needed because it will fail if you do not include this switch) - SUCCESS!!: Even though the feature was installed with success, it is a pain, because when you return to SQL Server install and click ok, it does not give you option of retrying the SQL Server install now that you fixed the failed feature. You have to let the entire rest of the install complete, with MANY errors (apparently MSFT makes a LOT of pieces of SQL Server 2012 dependent on .net 3.5!!!). Then once the orig install completes you will see something like this with many partial installed SQL Server 2012 features. You will then have to RERUN the SQL Server 2012 installer to pick up the bad things that were missed. Hopefully you wrote down the settings you used before! Good luck.

No comments: