Overview:

This issue occurs when you upgrade runtime to any version 95.2.85 and greater.

While trying to configure Application in the console.

When the user installed SqlServer module of a version V22 and greater

Workaround:

Inside the runtime directory edit the file update_sql_R95.ps1 under the Invoke-Sqlcmd and Add -TrustServiceCertificate

Restart runtime and adxadmin then Try again

Side note: User should add backtick ‘`’ on the previous line to show that there is a next command.

Note: this is already reported and will be resolved on the future releases or as hotfix.

Another way to fix this issue:

Remove the SqlServer Module 22.0.59 and replace it with 21.1.18256

Links:

https://learn.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps

https://learn.microsoft.com/en-us/sql/relational-databases/security/networking/tds-8-and-tls-1-3?view=sql-server-ver16#strict-connection-encryption

Assistance: JoseLuis