Drupal 6 on Windows with MS SQL Server

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
paddyguest's picture

Please can anyone help me. I have spent about two weeks on this now and it's driving me crazy. I'm sure it's a common question, but I can't seem to find the complete (idiot-proof!) solution anywhere.

I have been using Drupal 6 for a while now - I have 20-30 separate sites all running happily on the same Windows 2008 server, IIS, PHP 5.3.3 and MySQL. The problem is that I want to use MS SQL for the back-end for a number of reasons. I have tried Drupal 7 and successfully installed with SQL server as the back-end. The problem is that the installation is a little flaky - I don't know if it's the use of SQL server, the fact that it's Drupal 7, or the Workbench Access module (which I had to use as a replacement for menu_node_edit) that is causing the problem, but something is and it's erroring a lot! Also, the range of modules for D7 is nowhere near as good as for D6.

So, I have downloaded php_dblib.dll and modified the php.ini file to include this. I downloaded a couple more files from a Microsoft development project that seems to have been working on this issue. These files were
database.inc
database.sqlsrv.inc
install.sqlsrv.inc
With these files I can get sqlsrv to appear in the database list at install, but when I put the correct connection info in, it says there is already a drupal installation in that database (there isn't, it's empty), and the installation cannot proceed. The account I am using has dbo access to the relevant database.

If I change the connection string of an existing site, I can get Drupal to talk to the database - it errors because the table don't exist, but at least it appears to talk to the server. However, I cannot get it to install to the sql database.

Please can anyone help? If I can get this working, I promise to write a step-by-step guide to help others!

Many thanks
Paddy

Comments

I'm confused -- Are you doing

ben.bunk's picture

I'm confused --

Are you doing Drupal 6 or Drupal 7?

Is this an upgrade or a fresh install?

Sorry - I'll try to clarify

paddyguest's picture

It's Drupal 6 that I want to use. I've tried D7 but it's not suitable for what I need

I'm trying to do a fresh install.

Thanks
Paddy

It only works with Drupal 7

markjbrown's picture

The Drupal SQL Server module only works with Drupal 7, requires PDO support.

Thanks

paddyguest's picture

Thanks for this. However, I believe there still must be a way of using SQL server with Drupal 6. See for instance: http://www.youtube.com/watch?v=sZDgpLRNZe8

Thanks
Paddy

Might be this then

markjbrown's picture

I saw this some time ago. It's ancient and doesn't seem to be anybody currently maintaining. http://groups.drupal.org/node/1953

Still think D7 is going to be your best bet.

I got the driver used in that youtube