• Adam Thurgar

.NET Framework 3.5 SP1 required

I started doing an installation of SQL Server 2014 on Windows Server 2016 Datacenter.

The SQL Server installation iso had been downloaded, but no SSMS or service packs.

I downloaded SSMS 17.8 and then SP2 CU12 in preparation.

When I started the install it failed as it did not have the .NET Framework 3.5 SP1 installed.

Previously this would have been a case of downloading and installing, but now this has changed and the .NET Framework is now an OS installation feature.

When trying to add this feature it failed as the OS installation media files were not available.


I downloaded on ondemand cab file and extracted the files to a new folder and used this as the source for the installation. Still no success, so it was potentially back to the infrastructure team to install this feature, or try and change the group policy.

Following the instructions in this link to change to the group policy allowed the .NET Framework to be installed


Also if you need help accessing the group policy editor go to the following.


4 views0 comments

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t