Disable-DbaForceNetworkEncryption

Disables Force Encryption for a SQL Server instance. Note that this requires access to the Windows Server, not the SQL instance itself.
This setting is found in Configuration Manager.

Screenshots

dbatools - Add-DbaComputerCertificate

Examples

Disables Force Encryption on the default (MSSQLSERVER) instance on localhost – requires (and checks for) RunAs admin.

Disable-DbaForceNetworkEncryption

Disables Force Network Encryption for the SQL2008R2SP2 on sql01. Uses Windows Credentials to both login and modify the registry.

Disable-DbaForceNetworkEncryption -SqlInstance sql01\SQL2008R2SP2

Shows what would happen if the command were executed.

Disable-DbaForceNetworkEncryption -SqlInstance sql01\SQL2008R2SP2 -WhatIf

Author

This command was created by Chrissy LeMaire. You can find Chrissy on Twitter and his blog.