Install using existing SQL Server 2012

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
erg-web's picture
Posted by erg-web on January 22, 2014 at 4:04pm

Hi

Is there a direct download link for Drupal 7 for Windows?

Using web platform installer forces you to install a SQL Express instance which is not needed as we have a SQL Server 2012 database already in place and having both will cause problems.

Web PI wont let you install without a database selection or give you option to use existing SQL Server?

Categories:

Comments

Install using existing SQL Server 2012

Posted by terri8502 on January 22, 2014 at 5:04pm
terri8502's picture

I had the same issue with the installer, so I just let it do its thing in sql express then changed the settings.php page to point to the right database and uninstalled sql express. We have a separate db server from the web server. I know that's not what you asked but that was a quick way to do it for me, especially since the installer installed all the software for me.

You can install the php

Posted by ben.bunk on January 22, 2014 at 6:29pm
ben.bunk's picture

You can install the php module for IIS and get rolling fairly quickly without Web PI. Then just download the standard copy of drupal and the https://drupal.org/project/sqlsrv module. Once you have the sqlsrv module installed you can run the Drupal setup process as normal (https://drupal.org/documentation/install).

PHP - SQL server driver

Posted by erg-web on January 23, 2014 at 2:39pm
erg-web's picture

Thanks for the help - PHP installed fine. The SQL server drivers dont appear to have installed, following the instructions on

http://www.microsoft.com/en-us/download/details.aspx?id=20098

The PHP get info() page works fine but does not list sqlsrv under the config.

PHP.ini is below - all sqlsrv dlls are added as its not clear which should be used - thread safe or not - PDO or not?

Any ideas?

[WebPIChanges]

extension_dir = "C:\Program Files (x86)\PHP\v5.5\ext\"

[ExtensionList]

extension=php_sqlsrv_54_nts.dll
extension=php_sqlsrv_54_ts.dll
extension=php_pdo.dll
extension=php_pdo_sqlsrv_54_nts.dll
extension=php_pdo_sqlsrv_54_ts.dll

Drupal requires PDO to work

Posted by ben.bunk on January 23, 2014 at 4:17pm
ben.bunk's picture

Drupal requires PDO to work correctly - see the requirements here https://drupal.org/requirements

This page from Microsoft tells you which version of the php sql driver to use: http://msdn.microsoft.com/en-us/library/cc296170(v=sql.90).aspx

Typically you want the x86, non thread safe (nts), pdo driver that matches your version of PHP.

For information on the correct version of php see windows.php.net.

SQL drivers for PHP 5.5

Posted by erg-web on January 24, 2014 at 12:09pm
erg-web's picture

Thanks

With the drivers I was getting error

PHP Startup: pdo_sqlsrv: Unable to initialize module Module compiled with module API=20100525 PHP

Had to download drivers for 5.5 from

http://social.technet.microsoft.com/Forums/sqlserver/en-US/73a97526-8aa9...

then add

extension=php_sqlsrv_55_nts.dll
extension=php_pdo_sqlsrv_55_ts.dll

Now PHPINfo shows its all working

sqlsrv support enabled

Directive Local Value Master Value
sqlsrv.ClientBufferMaxKBSize 10240 10240
sqlsrv.LogSeverity 0 0
sqlsrv.LogSubsystems 0 0
sqlsrv.WarningsReturnAsErrors On On

Invalid object name 'watchdog' - end of installation

Posted by erg-web on January 27, 2014 at 11:21am
erg-web's picture

Thanks for help so far - the PHP and SQL drivers all worked as the install screen appeared. But at the very end the install fails with:

PDOException: SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'watchdog'. in dblog_watchdog() (line 160 of C:\inetpub\wwwroot******.org.uk\modules\dblog\dblog.module).

There is a thread on this:

https://drupal.org/node/1956770

I tried the fix to the warnings related to function removeFieldsInCondition in query.inc but the watchdog error still happens.