MS SQL Server 2014 installation and .NET 3.5 problem.

I was installing MS SQL Server 2014 on Windows Server 2012, and when running installation wizard I ran into following error:

So, my first thought was:

That would be eeeasssy as eating a banana!

So I went to the server manager and I ran feature installation from there, and there was a little surprise:

Installation of one or more roles, role services, or features failed.
The source files could not be found. Try installing the roles, role services, or features again in a new Add Roles and Features Wizard session, and on the Confirmation page of the wizard, click “Specify an alternate source path” to specify a valid location of the source files that are required for the installation. The location must be accessible by the computer account of the destination server.

Well…I didn’t expect that…

So I engaged uncle Google to that, and what I found was:

https://support.microsoft.com/en-us/kb/3002547

I have downloaded that NDPFixit-KB3005628-X64.exe file, double click on that, CMD window appeared for like a second and disappeared- that was quick!

Tried to run installation one more time – same error…

Googled a little bit more and found that:

https://social.technet.microsoft.com/Forums/en-US/5a786052-38a1-46f9-add2-e6487bc6a8aa/net-framework-20-and-35-feature-install-fails-on-windows-server-2012-rc?forum=winserver8setup

So firstly I ran a command:

dism.exe /online /enable-feature /featurename:NetFX3 /Source:D:\sources\sxs

That went good, but said I need to enable those features separately – no problemo!

After that I still saw no .net 3.5 installed…

So I have read deeper and actually there was a switch that was needed to be there in the command, the proper one should be:

dism.exe /online /enable-feature /featurename:NetFX3 /Source:D:\sources\sxs /LimitAccess

So I was missing “/LimitAccess” switch, what MSDN is telling under:

https://msdn.microsoft.com/en-us/library/windows/desktop/hh824737.aspx

BTW. I was installing Sharepoint 2013 application on W2k12 later and encountered similar error, so command that worked there was:

dism.exe /online /enable-feature /featurename:NetFX3 /Source:D:\sources\sxs /All /norestart

So, being honest I am not sure what is all about /LimitAccess why it was not working for me previously.

After that, I saw that .net 3.5 feature appeared in the installed features:

And installation of MS SQL Server 2014 also went well 😉