SQL server not available as option

[stefan111]

Hi there!

I am trying to setup Joomla! on a windows server with sql server. I'm also using WebMatrix.

During the installation there is an option where I'm supposed to be able to select SQL server, but there is only MySQL to choose.

I found this same question on the forum, but it didn't help:
http://forum.joomla.org/viewtopic.php?f=717&t=850225

Here's my exact configuration:

Windows Server 2008 R2 standard x64, SP1
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (Intel X86)
PHP 5.4.24
Microsoft Drivers 2.0 for PHP for SQL Server
IIS 7.5.7600.16385
WebMatrix 3

Notice that the sql server is 32 bit, running on a 64 bit OS. Could that be a problem here?

To make sure that the PHP driver for SQL server really works I have tried to make a connection with the sqlsrv_connect() command, and it worked.

However, there is still no SQL server option available.

Anyone seen this before?

[MusicalWebsites]

maybe these links will help

http://docs.joomla.org/Configuring_sqlserver

http://www.microsoft.com/web/joomla

[stefan111]

I have googled around a lot and been to those pages already, I'm affraid. But thanks anyway! At the moment I am running MySQL while learning Joomla. (Btw, I'm so impressed by Joomla!) We still may use SQL server for our customer, so this is still an open question. What I have seen in the Joomla administrator back-end site is that you can actually change the database and database server there. I haven't tried it though.

[alikon]

If you run phpinfo() did you notice the SQL srv detected as running from php?

[stefan111]

Well, it says "sqlsrv support enabled". Is that what you mean? I also tried the sqlsrv_connect() command, and it worked. However, I'm not a PHP guy, so these are deep waters for me.