Source MSSQL - The connection tests failed

Hey, thanks for the support.

I figured out with the IT team that the PORT number is not the default port number 1433 but a different port number for the named instance.

They said that internally the SQL server does a lookup for the instance and the client contacts the host on the default port no (1433), which then returns the port number for that instance and connects to it.