SQLServer as a System Database

1. 1. Drivers
      1. 1. Windows

• Download and install Microsoft ODBC Driver 11 for SQL Server (if not already installed). Currently this is available [here](http://www.microsoft.com/en-us/download/details.aspx?id=36434). In 32-bit environments, install the x86 package. In 64-bit environments, install the x64 package.
• Download and install the appropriate SQL Server Native Client (if not already installed and SQL Server is not hosted on the same machine as DSP). In 32-bit environments, install the x86 package. In 64-bit environments, install the x64 package. Currently the Microsoft SQL Server 2012 Native Client is available [here](http://www.microsoft.com/en-us/download/details.aspx?id=29065), and the Microsoft SQL Server 2008 R2 Native Client is available [here](http://www.microsoft.com/en-us/download/details.aspx?id=16978).
• DreamFactory uses PHP PDO drivers for DB connections. Full documentation on PDO_SQLSRV is available [here](http://php.net/manual/en/ref.pdo-sqlsrv.php). You will need to download and extract the Microsoft Drivers for PHP for SQL Server. Currently these are available [here](https://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx).
• Copy the DLLs for your version of PHP into your PHP's extensions directory. E.g., for PHP 5.5, the DLLs are php_pdo_sqlsrv_55_ts.dll and php_sqlsrv_55_ts.dll (which were extracted from the download in the third step). (Rare case: if you are integrating with IIS as your web server, use the non-thread-safe DLLs instead (php_pdo_sqlsrv_55_nts.dll and php_sqlsrv_55_nts.dll).)
• Enable the copied DLLs in your php.ini file. Using the example DLLs from step #4, you would add the following lines to C:\Bitnami\dreamfactory-2.0.1-1\php\php.ini and save:
  • ```extension=php_pdo_sqlsrv_55_ts.dll```
  • ```extension=php_sqlsrv_55_ts.dll```
• Restart your web server to apply these PHP configuration changes.