Actions

Difference between revisions of "Configuring sqlserver"

From Joomla! Documentation

m
m (Simple text formatting)
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 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).<br /><br />
1. Download SQLServer 2008 Express, SQLServer 2008 Standard/Enterprise editions (R2 or later)[[http://msdn.microsoft.com/en-us/sqlserver/bb671149.aspx DowpnloadSQLServer]]  
+
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]
+
2. Download PHP Drivers [http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17308 PHPDrivers]<br />
System requirements
+
3. System requirements
3. a) Download SQLSRV20.EXE to a temporary directory
+
  a) Download SQLSRV20.EXE to a temporary directory
 
   b) Run SQLSRV20.EXE
 
   b) Run SQLSRV20.EXE
 
   c) When prompted, enter the path to the PHP extensions directory
 
   c) When prompted, enter the path to the PHP extensions directory
4. If you are using some sort of LAMP stack like XAMPP -
+
4. If you are using some sort of LAMP stack like XAMPP
 
     copy php_sqlsrv_52_ts_vc6.dll to php/ext folder
 
     copy php_sqlsrv_52_ts_vc6.dll to php/ext folder
 
     make an entry in php.ini as follows
 
     make an entry in php.ini as follows
Line 15: Line 15:
 
           2. If you are using IIS with PHP engine installed via FAST-CGI - please make the appropriate changes in
 
           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
 
             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.
+
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 />
 
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]]
 
[[Category:Server configurations]]

Revision as of 12:21, 25 September 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
3. System requirements

  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.