[Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: The wait operation timed out

Need Help
1

Installed CakePHP 3.3 on XAMPP 3.2.4 with PHP 7.2.22 and MSSQL extensions loaded as
extension=php_pdo_sqlsrv_72_nts_x64.dll

Hello, please, I need help. :slight_smile:

I am able to connect to my TEST environment without issue. When I tried to connect to PROD, I got the error below:

Connection to Sqlserver could not be established: SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: The wait operation timed out.

image
image1326Ă—448 6.76 KB

The only difference that I see is that in PROD we need to include the INSTANCE name in the host.

image
image658Ă—707 10.3 KB

I have another app not running into CakePHP that works fine and connects to PROD env.

image
image1047Ă—415 6.68 KB

Please, could someone have an idea?
Thanks in advance.

BR
Dante

2

Solved with a workaround.
No idea why it wasn’t working. The params are the same: host, db, user, password…
I placed the string connection directly in the sqlserver.php file and it works fine.

image
image1327Ă—530 28.3 KB

3

Is it because your test configuration doesn’t include \ORMDBMSSQLSERVER in the hostname? That’s in the “directly in the sqlserver.php” code that you’ve shown, and the production config, but not the test config.