Add a core test logger to help capture the MSSQL container output

Add a core test logger to help capture the MSSQL container output #24236