If you are using an AdminStudio version before 2018R3, you may receive an error message stating that there is an SSL security error while connecting to the SQL database after enabling TLS 1.2 and disabling TLS 1.0 and TLS 1.1 on the server.
AdminStudio began supporting TLS 1.2 in versions 2018 R3 and above. If you’re using the AdminStudio version before 2018R3, you will not be able to connect to the SQL server where TLS 1.2 is enabled. However, if TLS 1.0 and TLS 1.1 are enabled, it will connect successfully to the SQL server. Follow the steps below to enable TLS 1.0 and 1.1.
Solution
- Navigate to the following paths in the SQL server and modify the values accordingly:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1
- Or set the TLS 1.0 and 1.1 client and server using the following PowerShell script.
$protocols = @{
'SSL 2.0'= @{
'Server-Enabled' = $false
'Client-Enabled' = $false
}
'SSL 3.0'= @{
'Server-Enabled' = $false
'Client-Enabled' = $false
}
'TLS 1.0'= @{
'Server-Enabled' = $true
'Client-Enabled' = $true
}
'TLS 1.1'= @{
'Server-Enabled' = $true
'Client-Enabled' = $true
}
'TLS 1.2'= @{
'Server-Enabled' = $false
'Client-Enabled' = $false
}
}
$protocols.Keys | ForEach-Object {
Write-Output "Configuring '$_'"
# create registry entries if they don't exist
$rootPath = "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\$_"
if(-not (Test-Path $rootPath)) {
New-Item $rootPath
}
$serverPath = "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\$_\Server"
if(-not (Test-Path $serverPath)) {
New-Item $serverPath
New-ItemProperty -Path $serverPath -Name 'Enabled' -Value '1' -PropertyType 'DWord'
New-ItemProperty -Path $serverPath -Name 'DisabledByDefault' -Value '0' -PropertyType 'DWord'
}
$clientPath = "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\$_\Client"
if(-not (Test-Path $clientPath)) {
New-Item $clientPath
New-ItemProperty -Path $clientPath -Name 'Enabled' -Value '1' -PropertyType 'DWord'
New-ItemProperty -Path $clientPath -Name 'DisabledByDefault' -Value '0' -PropertyType 'DWord'
}
# set server settings
if($protocols[$_]['Server-Enabled']) {
Set-ItemProperty -Path $serverPath -Name 'Enabled' -Value '1'
Set-ItemProperty -Path $serverPath -Name 'DisabledByDefault' -Value '0'
} else {
Set-ItemProperty -Path $serverPath -Name 'Enabled' -Value '0'
Set-ItemProperty -Path $serverPath -Name 'DisabledByDefault' -Value '1'
}
# set client settings
if($protocols[$_]['Client-Enabled']) {
Set-ItemProperty -Path $clientPath -Name 'Enabled' -Value '1'
Set-ItemProperty -Path $clientPath -Name 'DisabledByDefault' -Value '0'
} else {
Set-ItemProperty -Path $clientPath -Name 'Enabled' -Value '0'
Set-ItemProperty -Path $clientPath -Name 'DisabledByDefault' -Value '1'
}
}
Related Articles
Error 27502. Could Not Connect To Microsoft SQL Server Using TLS 1.2 (Transport Layer Security 1.2) 134Number of Views Failed to Download Beacon Policy after disabling SSL 3.0 and TLS 1.0 24Number of Views Failed to connect to Flexera Service Gateway with error "Could not create SSL/TLS secure channel." 14Number of Views Error: "The request was aborted: Could not create SSL/TLS secure channel" when calling api.flexera.com from Windows Server… 60Number of Views Installer is unable to create a database connection - working with TLS 1.2 7Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago