The target principle name is incorrect

[a8ball]

When running the WSUS database optimization I am getting the following:

Run WSUS database optimization? Y/N: y
Creating custom indexes in WSUS index if they don't already exist. This will speed up future database optimizations.
Invoke-Sqlcmd : A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL
Provider, error: 0 - The target principal name is incorrect.)
At K:\Powershell Scripts\Optimize-WsusServer.ps1:440 char:5

• Invoke-Sqlcmd -query $createCustomIndexesSQLQuery -ServerInstance ...
  

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

  • CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException
  • FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

Invoke-Sqlcmd : Incorrect syntax was encountered while parsing 'IF 0 = (SELECT COUNT(*) as index_count'.
At K:\Powershell Scripts\Optimize-WsusServer.ps1:440 char:5

• Invoke-Sqlcmd -query $createCustomIndexesSQLQuery -ServerInstance ...
  

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

  • CategoryInfo : ParserError: (:) [Invoke-Sqlcmd], BatchParserException
  • FullyQualifiedErrorId : ExecutionFailureException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

Running WSUS SQL database maintenence script. This can take an extremely long time on the first run.
Invoke-Sqlcmd : A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL
Provider, error: 0 - The target principal name is incorrect.)
At K:\Powershell Scripts\Optimize-WsusServer.ps1:444 char:5

• Invoke-Sqlcmd -query $wsusDBMaintenanceSQLQuery -ServerInstance $ ...
  

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

  • CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException
  • FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

Invoke-Sqlcmd : Incorrect syntax was encountered while parsing 'SET NOCOUNT ON;'.
At K:\Powershell Scripts\Optimize-WsusServer.ps1:444 char:5

• Invoke-Sqlcmd -query $wsusDBMaintenanceSQLQuery -ServerInstance $ ...
  

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

  • CategoryInfo : ParserError: (:) [Invoke-Sqlcmd], BatchParserException
  • FullyQualifiedErrorId : ExecutionFailureException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

[GitSheru]

Adding "-Encrypt Optional" at the end of each line of the script where Invoke-SQLCmd is used resolved this issue for me.