November 13, 2014 at 11:13 am
Morning,
We're suddenly getting the error "Msg 6510, Level 16, State 11, Line7 This functionality requires .NET Framework 3.5 SP1. Please install .NET Framework 3.5 SP1 to use this functionality."
On our SQL Server 2008 R2 databases with Geography data.
I've been told nothing has been updated or pushed to this server, but....
When I run sys.dm_clr_properties I get:
directory:
version:
state: mscoree is loaded
I've checked that 3.5 features are installed.
Restarted the server.
Any ideas are appreciated.
Thank, D
November 13, 2014 at 11:52 am
Is there a problem to install the service pack?
Gerald Britton, Pluralsight courses
November 13, 2014 at 12:10 pm
This is likely something with using SSMS, that is the only thing .NET 3.5 SP1 is required for with SQL Server.
It is actually a Windows Feature on the server or machine that is receiving the error. You can verify it is enabled by running this PowerShell command:
Import-Module servermanager
Get-WindowsFeature NET-Framework-Core
Get-WindowsFeatur
The output should look something like this:
Display Name Name
------------ ----
[X] .NET Framework 3.5.1 NET-Framework-Core
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
November 13, 2014 at 12:19 pm
Thanks,
We have up to v4.0.30319 installed on that server.
v2.0.50727
v3.0
v3.5
v4.0.30319
2008 using the framework for the geography types.
I'm getting errors when I try to dbcc checkdb on a database with geography types or
if I try to view a table with geography type columns. Applications are getting errors whenever trying to access the tables using geography types.
I've rebooted the server and tried setting a config file to point to 4.0.
Not sure why dm_clr_properties is not displaying framework version
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply