Issue

I have the following script to connect to my microsoft azure server.

<?php

try {
    $hostname = "secrets.database.windows.net";
    $dbname = "secrets";
    $username = "secrets";
    $pw = "secrets";
    $dbh = new PDO ("dblib:host=$hostname;dbname=$dbname","$username","$pw");
} catch (PDOException $e) {
    echo "Failed to get DB handle: " . $e->getMessage() . "\n";
    exit;
}

echo "Passed!";

The script above passes on my old server, but gives me the following error message when executed from new server.

SQLSTATE[01002] Adaptive Server connection failed (severity 9)

My new server PHP setup is as follows:

sudo apt-get install -y php5.6-fpm php5.6-ldap php5.6-curl php5.6-cli   php5.6-mcrypt php5.6-intl php5.6-json php5.6-pdo-dblib php5.6-mysqlnd php5.6-memcached php5.6-mbstring php5.6-imap php5.6-xml php5.6-sybase

My checks so far:

1) Both have same public facing IP address.

2) Both have identical PHP PDO/ODBC setup.

$ php -i | grep PDO
DO
PDO support => enabled
PDO drivers => dblib, mysql, odbc
PDO Driver for FreeTDS/Sybase DB-lib => enabled
PDO Driver for MySQL => enabled
PDO_ODBC
PDO Driver for ODBC (unixODBC) => enabled

3) I am able to ping my server using telnet from both servers using:

telnet secrets.database.windows.net 1433

Any suggestions would be appreciated.

Solution

After some further googling I came across this answer.

Connect PHP to MSSQL via PDO ODBC

Turned out I just needed to update my /etc/freetds/freetds.conf

My changes:

Uncommented TDS protocol version and updated.

tds version = 8.0

Added mssql below examples.

[mssql]
host =
Port = 1433
tds version = 8.0

Answered By - hawx

Monday, January 3, 2022

[SOLVED] SQLSTATE[01002] Adaptive Server connection failed (severity 9)

Issue

Solution