Actions

Difference between revisions of "Configuring sqlserver"

From Joomla! Documentation

m (Simple text formatting)
m (Improve formatting more :))
 
Line 1: Line 1:
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.
+
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).<br /><br />
+
==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)[[http://msdn.microsoft.com/en-us/sqlserver/bb671149.aspx DowpnloadSQLServer]] <br />
+
 
2. Download PHP Drivers [http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17308 PHPDrivers]<br />
+
# Download SQLServer 2008 Express, SQLServer 2008 Standard/Enterprise editions (R2 or later)[[http://msdn.microsoft.com/en-us/sqlserver/bb671149.aspx DowpnloadSQLServer]]
3. System requirements
+
# Download PHP Drivers [http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17308 PHPDrivers]
  a) Download SQLSRV20.EXE to a temporary directory
+
# System requirements
  b) Run SQLSRV20.EXE
+
#*Download SQLSRV20.EXE to a temporary directory
  c) When prompted, enter the path to the PHP extensions directory
+
#*Run SQLSRV20.EXE
4. If you are using some sort of LAMP stack like XAMPP
+
#*When prompted, enter the path to the PHP extensions directory
    copy php_sqlsrv_52_ts_vc6.dll to php/ext folder
+
# If you are using some sort of LAMP stack like XAMPP
    make an entry in php.ini as follows
+
#*Copy php_sqlsrv_52_ts_vc6.dll to php/ext folder
    extension=php_sqlsrv_52_ts_vc6.dll
+
#*Make an entry in php.ini as follows
    Note: 1. if you need PDO or vc9 versions - please copy the "ts" version appropriate for your needs.
+
#*Extension=php_sqlsrv_52_ts_vc6.dll
          2. If you are using IIS with PHP engine installed via FAST-CGI - please make the appropriate changes in
+
#*Note:
            c:\Program Files\php\php.ini and copy the dll to c:\Program Files\php\ext folder
+
#*#If you need PDO or vc9 versions - please copy the "ts" version appropriate for your needs.
5. Now - You can install Joomla 2.5 by selecting the SQLServer 2008 from the dropdown list in the step 4 of the installation.<br />
+
#*#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
6. After installation is complete - continue navigation around the administrator/site.
+
# Now - You can install Joomla 2.5 by selecting the SQLServer 2008 from the dropdown list in the step 4 of the installation.<br />
 +
# After installation is complete - continue navigation around the administrator/site.
  
 
[[Category:Server configurations]]
 
[[Category:Server configurations]]

Latest revision as of 15:39, 25 September 2013

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)

  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.