April 23, 2020 at 10:33 am
Hi,
I need to upgrade .net framework from 4.0 to 4.5.2 because of vulnerability issue.
After .net framework installed, anyone how to change the SQL server and Server Management Studio to use .net framework 4.5.2 ?
Calvin
April 23, 2020 at 2:18 pm
You don't change SSMS to use a version. They choose the ones required. That's the advantage of .NET. The developer targets a version, and multiple versions of .NET can coexist.
April 24, 2020 at 4:17 am
The .net framework 4.0 is end of support and no furhter security update. Because of security requirement, we need to turn it off and adopt higher version support version. .NET cannot co-exist. Then if will turn old .NET off. Do we need to make change on SQL server and SSMS ?
April 24, 2020 at 8:11 am
Microsoft will define the .Net version. If you need to run a specific version of .Net you need to run a specific version of SQL server and SSMS.
Check the product documentation for the specific hardware / software requirements.
eg. 2005 needs .Net2, 2008 needs .Net2 or .Net3.5 depending on what your installing, 2012&2014 needs .Net3.5 and .Net4, 2016&2017 is .Net 4.6, 2019 is whatever ships with Server2016 or above.
So if your running 2014 or below you cannot uninstall the lower versions otherwise you break SQL
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms143506(v=sql.105)?redirectedfrom=MSDN
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms143506(v=sql.110)?redirectedfrom=MSDN
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply