Pemasangan PHP SqlServer di Linux Mint 18.1

Berikut Langkah-langkah pemasangannya :

1. Register the Microsoft Linux repositories and add their keys

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

curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list | sudo tee /etc/apt/sources.list.d/mssql-server-2017.list

2. Install SQL Server

sudo apt-get update 

sudo apt-get install mssql-server

3. Setup SQL Server

sudo /opt/mssql/bin/mssql-conf setup

4. Install PHP 7.0

sudo apt-get -y install php7.0 libapache2-mod-php7.0 mcrypt php7.0-mcrypt php-mbstring php-pear php7.0-dev apache2

5. Install the ODBC Driver and SQL Command Line Utility for SQL Server

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

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-tools.list 

sudo apt-get update 

sudo ACCEPT_EULA=Y apt-get install 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

6. Testing SQL Server

sqlcmd -S localhost -U sa -P yourpassword -Q "SELECT @@VERSION"

7. Install sqlsrv.so

sudo pecl install sqlsrv 

sudo pecl install pdo_sqlsrv 

Note: Jika saat pemasangan terdapat error, coba cek di c++ nya (mpu-nya install g++ terlebih dahulu kemudia eksekusi lagi sqlsrv)

8. Register into php.ini

extension=sqlsrv.so 

extension=pdo_sqlsrv.so

Jika ingin menyalakan, mematikan dan lihat status SQL Server

systemctl start mssql-server 

systemctl stop mssql-server 

systemctl status mssql-server

Sumber Terkait :
https://github.com/Microsoft/msphpsql/issues/298
https://www.microsoft.com/en-us/sql-server/developer-get-started/php/ubuntu/