Hello,
As many of you may know the latest round updates have disabled TLS 1.0 and TLS 1.2
For us that meant either enabling TLS everywhere or using newer methods. Below is a URL to enable:
https://blogs.windows.com/msedgedev/2020/03/31/tls-1-0-tls-1-1-schedule-update-edge-ie11/
A much better option is to install Microsoft® ODBC Driver 13.1 for SQL Server on the clients:
https://www.microsoft.com/en-us/download/details.aspx?id=53339
Then update a whole bunch of ODBC system DSNs.
Thats great but some of our Citrix servers have a lot of system DSNs and I didnt much fancy doing them one by one so here’s some PowerShell to do it for you:
$DsnArray = Get-OdbcDsn -DriverName 'SQL Server' ForEach ($Dsn in $DsnArray) { Remove-OdbcDsn -InputObject $Dsn Add-OdbcDsn -Name $Dsn.Name -DsnType $Dsn.DsnType -Platform $Dsn.Platform -DriverName 'ODBC Driver 13 for SQL Server' -SetPropertyValue $Dsn.PropertyValue }
Boom.
Leave a Reply