J3.x

Configuring sqlserver

From Joomla! Documentation

Joomla 2.5 and higher supports SQLServer. The prerequisites to install and configure SQLServer before installing Joomla on SQLServer database instead of the traditional MySQL. SQLServer Express is great alternative especially if any one wants to leverage the power of Microsoft software stack within Joomla.

Case 1: Joomla running on SQLServer database on single machine (Development purposes)[edit]

  1. Download SQLServer 2008 Express, SQLServer 2008 Standard/Enterprise editions (R2 or later)[DowpnloadSQLServer]
  2. Download PHP Drivers PHPDrivers
  3. System requirements
    • Download SQLSRV20.EXE to a temporary directory
    • Run SQLSRV20.EXE
    • When prompted, enter the path to the PHP extensions directory
  4. If you are using some sort of LAMP stack like XAMPP
    • Copy php_sqlsrv_52_ts_vc6.dll to php/ext folder
    • Make an entry in php.ini as follows
    • Extension=php_sqlsrv_52_ts_vc6.dll
    • Note:
      1. If you need PDO or vc9 versions - please copy the "ts" version appropriate for your needs.
      2. If you are using IIS with PHP engine installed via FAST-CGI - please make the appropriate changes in c:\Program Files\php\php.ini and copy the dll to c:\Program Files\php\ext folder
  5. Now - You can install Joomla 2.5 by selecting the SQLServer 2008 from the dropdown list in the step 4 of the installation.
  6. After installation is complete - continue navigation around the administrator/site.