These are more of a collection of links than an actual tutorial; my personal experience with installing MSSQL drivers in a PHP/Apache webserver was born out of the need to migrate timekeeping data from a proprietary 3rd party database into one of my own.
You’ll need the following pre-requisites downloaded:
- MSSQL (2012 is tested)
- PHP 7 (7.2.5 and 7.2.9 is tested)
- (optional) To test MSSQL connection: DBVisualizer
- MSSQL Drivers
- Microsoft JDBC Driver 6.0 for SQL Server
- Microsoft Drivers 5.3 for PHP for SQL Server (Windows) (Linux)
- PHP JBDC Drivers
Procedure
Instead of writing my own installation steps, I followed @nahomt‘s tutorial. In case that link isn’t available, serverpilot.io has another tutorial that looks similar.