SQL Server Connectivity Test

Uses PDO (pdo_sqlsrv) to reach the `alm` database and sample T_Drivers.

Current target: 221.133.45.235:14880 as sa.

Connection failed after 50.7 ms.

Error: SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate]

Connection Attempts

Attempt Encrypt Trust Cert Status Duration (ms) Error
Env-provided false true error 17 SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:0A0C0103:SSL routines::internal error]
Encrypt + trust cert true true error 16.43 SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:0A0C0103:SSL routines::internal error]
Encrypt strict true false error 17.27 SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate]

Configure Credentials

Set DB_HOST, DB_PORT, DB_NAME, DB_USER, DB_PASS, optional DB_ENCRYPT (defaults to false), and optional DB_TRUST_SERVER_CERTIFICATE (defaults to true) before hitting this page. Defaults above are placeholders only.

The script starts with your env values and then cycles through a few encrypt/trust combinations automatically; check the attempt table above to see which combo (if any) worked.

Example: DB_HOST=10.0.0.12 DB_USER=sa DB_PASS=secret DB_ENCRYPT=false DB_TRUST_SERVER_CERTIFICATE=true php -S 0.0.0.0:8000 index.php