Instalación de ODBC en Linux para conexión con MSSQL

Step 1. Install PHP

sudo su

apt-get update

apt-get -y install php7.0 mcrypt php7.0-mcrypt php-mbstring php-pear php7.0-dev php7.0-xml

Step 2. Install prerequisites

sudo su

curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add –

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

exit

sudo apt-get update

sudo ACCEPT_EULA=Y

apt-get install msodbcsql mssql-tools

sudo apt-get install unixodbc-dev

echo ‘export PATH=”$PATH:/opt/mssql-tools/bin” ‘ >> ~/.bash_profile

echo ‘export PATH=”$PATH:/opt/mssql-tools/bin” ‘ >> ~/.bashrc

source ~/.bashrc

Step 3. Install the PHP drivers for Microsoft SQL Server

sudo pear config-set php_ini php –ini | grep “Loaded Configuration” | sed -e “s|.*:\\s*||” system

sudo pecl install sqlsrv

sudo pecl install pdo_sqlsrv

---

CONSIDERACIONES

Ejecutar phpinfo() y ver que están correctamente instalados los drivers PDO para SQLSRV.

Crear 2 ficheros en /etc/php/7.0/mods-available

pdo_sqlsrv.ini –> extension=pdo_sqlsrv.so

sqlsrv.ini –> extension=sqlsrv.so

Y habilitar SQL Server para que no solamente escuche desde localhost / 127.0.0.1

I had the same problem trying to connect with:

sqlcmd -S <ip> \\\\SQLEXPRESS, 1433 -d DATABASE -U username -P password

The fix for letting the Ubuntu client connect was to set “Listen to All” to No in the SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for (instance name).

And under IP Address change 127.0.0.1 to the (ip) used to connect.

Hay que deshabilitar los puertos dinamicos, quitar el 0, poner 1433, y poner la ip del servidor.

---

FUENTES:

https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017

https://www.microsoft.com/en-us/sql-server/developer-get-started/php/ubuntu