-
Story
-
Resolution: Unresolved
-
Undefined
-
None
-
ansible-collection-microsoft-sql-2.5.2-1.el10
-
None
-
rhel-sst-system-roles
-
5
-
QE ack, Dev ack
-
False
-
-
Yes
-
None
-
Pass
-
-
Automated
-
Enhancement
-
-
Proposed
-
None
Enhancement: Add mssql_tools_versions variable to allow installing different versions of mssql-tools package.
Add mssql_tls_self_sign variable for specifying whether self-signed certificates are used, applicable when users set mssql_tls_enable: true.
Reason: Microsoft added a new version of the mssql-tools package - mssql-tools18. This package adds some new functionality, which is not backward-compatible with the previous versions, hence Microsoft added a new package mssql-tools18 instead of just bumping the version of mssql-tools.
With mssql-tools18, when self-signed TLS certificates are used, it is required to set -C flag with sqlcmd to trust certificates.
Result: You can set mssql_tools_versions to install version 17, 18, or both version in parallel. By default, the role now installs the newer mssql-tools18.
With mssql-tools18, when you use self-signed TLS certificates, you must set mssql_tls_self_sign: true to make sqlcmd trust your certificates.
More details in Microsoft blog: https://techcommunity.microsoft.com/blog/sqlserver/odbc-driver-18-0-for-sql-server-released/3169228
- clones
-
RHEL-68374 Add variable for installing different versions of mssql_tools
- Integration
- links to
-
RHEA-2024:143551 ansible-collection-microsoft-sql bug fix and enhancement update