Using Joomla 2.5+ on Apache server with MS SQL database

Rate this item
(1 Vote)

One of recommended solution to use Joomla (2.5+) with MS SQL Server is WebMatrix platform with Joomla 2.5 Application avaiable on http://www.microsoft.com/web/joomla. This combination is very "packaged" with IIS web server and it uses limited tools to work with database. After practical evaluation of Joomla with WebMatrix I was not satisfied with given tools and operation. Much better solution I found with single installation of MS SQL Server 2008 R2(SP1) with Tools and running Joomla on Apache server with PHP extension php_sqlsrv_..dll.

Download of MS SQL Server 2008R2 with SP1 :
http://www.microsoft.com/en-us/download/details.aspx?id=26729

select version with Tools SQLEXPRWT_x64_ENU.exe or SQLEXPRWT_x86_ENU.exe (depends on used OS).

For using MSSQL Server with PHP is necessary to install specific PHP extension. Download it from link :
http://www.microsoft.com/en-us/download/details.aspx?id=20098. For latest versions of PHP5.3 use SQLSRV20.EXE package. After execution of this file you can find in selected temp directory unpacked bunch of different dll's. Based on used PHP version (and compilation) choose appropriate extension file - I selected php_sqlsrv_53_ts_vc9.dll. Put this file in PHP subdirectory ext and add to php.ini following extension definition as :

extension="C:\PHP53\ext\php_sqlsrv_53_ts_vc9.dll"

Restart Apache server and look on phpinfo() printout - it shall include 'sqlsrv' section with information 'sqlsrv support - enabled'.

Install MS SQL Server and then open SQL Server Configuration manager. Check if SQL server is running. In SQL Server Network Configuration set in section Protocols for SQLEXPRESS :

Then open MS SQL Server Management Studio and create in Security/Logins section new user for Joomla application access :

Disable here 'Enforce password policy'. Set server roles and membership as follows :

Then it is possible use following data for Joomla connection to the MS SQL server ('sqlsrv').

Read 1716 times Last modified onMonday, 22 October 2012 20:45

Only registred users have rights to post comments. Please log-in or create an account.

We have 43 guests and no members online
Copyright © 2015 JotComponents
We have 43 guests and no members online
Copyright © 2017 JotComponents