Difference between revisions of "Configuring sqlserver"
From Joomla! Documentation
(Created page with "Joomla 2.5 support SQLSErver. The prerequisites to install and configure SQLServer before installing Joomla on SQLServer database instead of the traditional MySQL. SQLServer Expr...") |
m |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | Joomla 2.5 support | + | Joomla 2.5 support 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. | Case 1: Joomla running on SQLServer database on single machine (Development purposes. | ||
| Line 17: | Line 17: | ||
5. Now - You can install Joomla 2.5 by selecting the SQLServer 2008 from the dropdown list in the step 4 of the installation. | 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. | 6. After installation is complete - continue navigation around the administrator/site. | ||
| + | |||
| + | [[Category:Server configurations]] | ||
Revision as of 18:45, 20 June 2013
Joomla 2.5 support 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. 1. Download SQLServer 2008 Express, SQLServer 2008 Standard/Enterprise editions (R2 or later)[DowpnloadSQLServer] 2. Download PHP Drivers PHPDrivers System requirements 3. a) Download SQLSRV20.EXE to a temporary directory
b) Run SQLSRV20.EXE c) 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.