0

I am looking for the powershell scripts/commands to get the details of below points
| Key | OutPut |
| ------------------------------ | ---------------- |
| Seurity [FIPS Alogithm Policy] | Enabled/Disabled |
| Is Client SSL 2.0 Enabled? | Enabled/Disabled |
| Is Server SSL 2.0 Enabled? | Enabled/Disabled |
| Is Client SSL 3.0 Enabled? | Enabled/Disabled |
| Is Server SSL 3.0 Enabled? | Enabled/Disabled |
| Is Client TLS 1.1 Enabled? | Enabled/Disabled |
| Is Server TLS 1.1 Enabled? | Enabled/Disabled |
| Is Client TLS 1.2 Enabled? | Enabled/Disabled |
| Is Server TLS 1.2 Enabled? | Enabled/Disabled |

I have tried the below code but getting different different errors.

$Socket = New-Object System.Net.Sockets.Socket([System.Net.Sockets.SocketType]::Stream, [System.Net.Sockets.ProtocolType]::Tcp)
$Socket.Connect($ComputerName, $Port)
$NetStream = New-Object System.Net.Sockets.NetworkStream($Socket, $true)
$SslStream = New-Object System.Net.Security.SslStream($NetStream, $true)
$SslStream.AuthenticateAsClient($ComputerName, $null, $ProtocolName, $false)

I have Sql Server 2014 installed with the latest updates.

I am looking for the Correct Powershell scripts to get the details for the FIPS Algorithm status and the status of protocol (SSL and TLS) for client/server. I tried the above code but its not working.

Prashant Kankhara
  • 1,498
  • 4
  • 15
  • 30
  • 2
    What errors exactly? – marsze Oct 27 '20 at 21:08
  • Are you [actually](https://meta.stackexchange.com/q/66377) trying to find out which encryption protocols are supported by the SQL Server installation? – vonPryz Oct 28 '20 at 06:56
  • Will share the error today. @marsze. Earlier it was "Connection Rejected by host" but now it says that "Algorithm do not match". – Prashant Kankhara Oct 29 '20 at 05:22
  • @vonPryz:- Yes, I want to know whether FIPS algorith is enabled for SQL Server and SSRS both and then want to know the details of protocols (SSL and TLS) client / server is enabled or disabled. – Prashant Kankhara Oct 29 '20 at 05:22

0 Answers0