[Bug]: Fix failing MS SQL Integration tests in the pipeline

[anushakolan]

What happened?

The MS SQL Integration tests in the pipeline are failing randomly with 503 Service Unavailable exceptions.
Ex: https://github.com/Azure/data-api-builder/pull/2943/checks?check_run_id=56413554625

The count of failures and the tests that are failing seem to be random. We need to understand what is causing the flakiness and fix it.

Version

Latest pipeline version

What database are you using?

Azure SQL

What hosting model are you using?

No response

Which API approach are you accessing DAB through?

No response

Relevant log output

Failures: 

Class Initialization method Azure.DataApiBuilder.Service.Tests.UnitTests.ODataASTVisitorUnitTests.SetupAsync threw exception. Microsoft.Data.SqlClient.SqlException: Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=5179; handshake=19; .


Assert.AreEqual failed. Expected:<BadRequest>. Actual:<ServiceUnavailable>.

Code of Conduct

• I agree to follow this project's Code of Conduct

[aaronburtle]

Another example: https://dev.azure.com/sqldab/Data%20API%20builder%20Dependency%20Packages/_build/results?buildId=15514&view=logs&j=2d2b3007-3c5c-5840-9bb0-2b1ea49925f3&t=f2696cc9-a35b-5158-31dc-9689759fe573