SSL Error on first run

[Pustuleo]

I know this has something to do with my certificates but to be honest certs are a area i struggle to grasp so i know i am thinking i have something miss configured but if someone could help that would be great.

Run WSUS server optimization? Y/N: y
Deleting obsolete computers from WSUS database
Invoke-WsusServerCleanup : The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure
channel.
At C:\Scripts\Optimize-WsusServer.ps1:388 char:5

• Invoke-WsusServerCleanup -CleanupObsoleteComputers
  

• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidData: (Microsoft.Updat...rCleanupCommand:InvokeWsusServerCleanupCommand) [Invoke-WsusServerCle
    anup], WebException
  • FullyQualifiedErrorId : ServerIsInvalid,Microsoft.UpdateServices.Commands.InvokeWsusServerCleanupCommand

I checked my certs, they are not expired and they include the FQDN.

thanks.

[TheBootsman]

Add -TrustServerCertificate to the end of lines 440 and 444

Invoke-Sqlcmd -query $createCustomIndexesSQLQuery -ServerInstance $serverInstance -QueryTimeout 120 -TrustServerCertificate

[Pustuleo]

Add -TrustServerCertificate to the end of lines 440 and 444

Invoke-Sqlcmd -query $createCustomIndexesSQLQuery -ServerInstance $serverInstance -QueryTimeout 120 -TrustServerCertificate

Thanks for the suggestion. Unfortunately it did not resolve the issue. still getting the same error

[PaulDuthie]

I had to add this to the end of lines 440 and 444

-encrypt optional

Which then worked