Install using existing SQL Server 2012

erg-web's picture

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?

Comments

Install using existing SQL Server 2012

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

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

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

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

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

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.

Drupal on Windows

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: