mssqlwin1 connection denied from jumpwin1

[doherty100]

Please provide us with the following information:

This issue is for a: (mark with an x)

- [ X ] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

Provision #AzureSandbox Complete smoke testing for terraform-azurerm-vm-mssql

Any log messages given by the failure

SQL Server Connection denied from SSMS on jumpwin1.

Expected/desired behavior

Connection should succeed

OS and Version?

Windows Server 2022 / SQL Server 2022

Versions

AzureSandbox v2.9.2

Mention any other details that might be useful

---

Thanks! We'll be in touch soon.

[doherty100]

Connection error from SQL Management studio is"

TITLE: Connect to Server
------------------------------

Cannot connect to mssqlwin1.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server, Error: -2146893019)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver--2146893019-database-engine-error

------------------------------

The certificate chain was issued by an authority that is not trusted

------------------------------
BUTTONS:

OK
------------------------------

[doherty100]

In SSMS v20.1, default connection security behavior has changed to set encryption to Mandatory. The fix is to change this to optional which is a documentation change.