Home / Questions / 2050
Accepted
Santiago
Asked: 2020-01-05 11:52:52 +0800 CST 2020-01-05 11:52:52 +0800 CST

How to connect Drupal 7 with MS SQL and IIS 7?

  • 772

I'm setting up a Drupal website connected to MSSqland IIS7but I'm having problems installing Drupal, mostly because of an error that I get in the fourth step. Here the data:

  • OS Windows 7 Ultimate
  • MS SQL Server 2014 express (SQLEXPRADV_X64_ES).
  • Drupal 7.41.
  • PHP 5.5.12 (installed with wampserver 2.5 x86)
  • IIS 7.5
  • php_pdo_sqlsrv_55_ts.dll
  • php_sqlsrv_55_ts.dll
  • php_wincache.dll

I have been guided by this tutorial but the problem is in the WinCache. In addition to using the PHP Managerdel IIS.

Error in the fourth step

This is where I have stayed. I have searched for the solution and even downloaded a DLL.

  • php_wincache.dll (wincache-1.3.5-5.5-nts-vc11-x86.exe)

And when I see phpinfo();it, I get that the SQL Server libraries are loaded but not the WinCache one.

Another message that I got when starting the wamp was:

warning when starting wamp

Suddenly I have to change the versions of something or some configuration that I have been missing since searching in google I have found very little.

php

1 Answers

  1. Best Answer

    If you want to start a Drupal running IIS with SQL Server,

    you must have the following:

    • Microsoft WebMatrix as IDE -> raise an IIS Express and with an addon we have support for PHP
    • Drupal Core 7.21
    • Drive Drupal for SQL
    • SQL Server 2008 Express

    .

    1. Once we download and unzip the Drupal Core somewhere on our hard drive, where we will proceed to "paste" the drupal driver for SQL Server, as follows: enter image description here

    2. We create our database in SQL Server. enter image description here

    3. We open the drupal folder with WebMatrix enter image description here

    4. In configuration, we make sure that PHP is enabled enter image description here

    5. We connect to the database from WebMatrix enter image description here

    6. We click on the execute button and we have as a result: enter image description here

    The above is based on the tutorial I wrote a few years ago: https://fredyfx.wordpress.com/2013/03/18/drupal-en-iis-con-sql-server/

    We make use of Microsoft WebMatrix to achieve this. I hope you find it useful, blessings.

    Freddy

    • 4