Detailed Description

The newest version of sqlcmd shipped in SQL Server 2025 now defaults to require trusted certificates per default.
sqlcmd is used in mssql_session, but there is no option on the resource to pass the -C flag to not require the client to trust the server certificate.

Context

This breaks some code that does not have trust set up, but used to work with the old default before SQL Server 2025.
Like kitchen test environments for example.

Possible Implementation

Add an attribute to the mssql_session resource