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

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