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 succeeded in 34.02 ms.

Connection Attempts

Attempt Encrypt Trust Cert Status Duration (ms) Error
Env-provided false true success 34.02 n/a
ID NAME HANDPHONENO TAGNO ADDRESS1 ADDRESS2 ADDRESS3 POSTCODE ADDRESSCITY ADDRESSSTATE c_Race c_BlockingOwner c_BlockingReason d_BlockingDate c_BlockingDepartment c_Type d_SU_StartDate d_SU_StartPayDate d_SU_EndDate d_SU_StartPayLoanDate PJPU_Id GENDER DateOfBirth AGE HOUSEPHONENO IC_ADDRESS1 IC_ADDRESS2 IC_ADDRESS3 IC_POSTCODE c_DrivingLicenseNo c_PSV c_SmsAllowed m_PayWelfare c_MaritalStatus c_TrunkRadioInstalled c_TrunkRadioSerialNo c_Religion c_Scheme c_Nationality d_ExpiryDate c_AccountNo c_Group c_AccountName c_AccountICNo c_BackupGroup c_Nickname c_Email c_Unknown c_Breakdown c_Tin
ALM TEST' DRIVER 1000 NO 111', JALAN2 '' M ALM SERVER NO LIMO ASSIGNED 2010-02-26 00:00:00.000 ALL X 2010-02-25 00:00:00.000 2010-02-25 00:00:00.000 2010-02-26 00:00:00.000 2015-01-01 00:00:00.000 L 0 Y 5.0000 SINGLE N I SUB MALAYSIAN
CAR POOL 18 6918 M ALM SERVER NO LIMO ASSIGNED 2010-01-21 00:00:00.000 ALL X 2009-12-28 15:07:15.310 2009-01-01 00:00:00.000 2010-01-21 00:00:00.000 2015-01-01 00:00:00.000 L 0 Y 5.0000 SINGLE N I CPL MALAYSIAN
CANCELLATION TICKET 9998 M ALM SERVER SUDAH BERHENTI KERJA 2009-07-08 00:00:00.000 ALL X 2009-07-07 00:00:00.000 2009-07-07 00:00:00.000 2015-01-01 00:00:00.000 L 0 Y 5.0000 SINGLE N I SUB MALAYSIAN
0 DUMMY ID FOR VEHICLE WITH NO JP 0 0 X ALM SERVER SUDAH BERHENTI KERJA 2018-10-25 00:00:00.000 ALL X 2012-01-01 00:00:00.000 L 30 Y 3.0000 N CPL MALAYSIAN D
0 MOHD RAMLI BIN OTHMAN 0 1434 169 LRG TERATAI SG TUA 68 100 BT CAVES SEL 68100 M ALM SERVER NO LIMO ASSIGNED 2007-04-15 00:00:00.000 ALL X 2007-04-15 00:00:00.000 2012-01-01 00:00:00.000 L 0 169 LRG TERATAI SG TUA 68 100 BT CAVES SEL 68100 Y 5.0000 SUL

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