MS SQL Connection String Format

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:

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.