Backport of Add a core test logger to help capture the MSSQL container output into release/1.17.x

Backport of Add a core test logger to help capture the MSSQL container output into release/1.17.x #16358