Follow these steps to create a connection to MS SQL Server:
note: This connection is applicable to all Operating Systems.
1) Start by making sure everything on the SQL Server side is properly configured.
Please follow this guide:
Solving SQL Server Connection Problem - Visual Paradigm Know-how
2) Download the SQL Server connection drivers for PHP
a. Download both the SQLSRV driver and also the PDO driver:
i. php_sqlsrv_54_ts.dll
ii. php_pdo_sqlsrv_54_ts.dll
note: This will be based on the PHP version you’re running (5.4)
b. Put these files in PHP -> EXT directory
3) To enable these drivers, add the following lines to the end of you php.ini file, which is located in the PHP folder
;sqlserver connection driver
extension=php_sqlsrv_54_ts.dll
extension=php_pdo_sqlsrv_54_ts.dll
4) Restart Apace
5) Create a service within your DSP to connect to MS SQL Server.
a. Connection strings are auto-generated based on host, port, and database name.
Send an email support@dreamfactory.com if these steps don’t work.