Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Installing SQL Secure with secured communications protocols

SQL Secure supports TLS 1.2 communications protocols.

Windows 8.1, Windows Server 2012 R2, Windows 10, Windows Server 2016, and later versions of Windows natively support TLS 1.2 for client-server communications over WinHTTP.

If you are still having TLS related problems, Verify the value of the DefaultSecureProtocols registry setting, for example:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\WinHttp\
DefaultSecureProtocols = (DWORD): 0xAA0
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Internet Settings\WinHttp\
DefaultSecureProtocols = (DWORD): 0xAA0

More information can be found here: https://learn

You can use IDERA SQL Secure to audit and assess your SQL Server security in environments where Federal Information Processing Standard (FIPS) compliance is required.

...

.microsoft.com/en-us/

...

Newtab2
aliasMicrosoft Knowledge Base Article #811833
urlhttp://support.microsoft.com/kb/811833

...

Newtab2
aliashttp://support.microsoft.com/kb/811833
urlhttp://support.microsoft.com/kb/811833

...

Verifying whether your environment requires FIPS compliance

...

mem/configmgr/core/plan-design/security/enable-tls-1-2-client

An alternative to manually changing registry keys, is to usea third party application called IISCrypto here: https://www.nartac.com/products/iiscrypto

Image Added

This will simply allow you to set Schannel best practices.

Scroll pdf ignore
Excerpt

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse