Problem/Motivation

Some servers require additional config options to be supplied in order to connect correctly, for example high availability clusters with with multi-subnet failover which need the MultiSubnetFailover=1 option.

Proposed resolution

Add support for all sqlsrv specific options using a similar approach to Laravel's SqlServerConnector::getSqlSrvDsn with config options being defined in underscore case in the settings.php array.

Issue fork sqlsrv-3291464

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

pstewart created an issue. See original summary.

pstewart’s picture

pstewart commented
Issue summary: View changes

Slight tweak to the issue summary to reflect that MultiSubnetFailover=yes should in fact be MultiSubnetFailover=1 to actually work.

I've now pushed a patch which ports over the option setting code from the Laravel connector to allow multi_subnet_failover and other options to be set in settings.php in the same way as they would be specified in a Laravel config/database.php config array. This is working as intended for my use case, allowing me to connect to a production SQL Server 2017 high availability cluster with multi-subnet failover. I'll open a merge request now.

pstewart opened merge request !80

pstewart’s picture

pstewart commented
Assigned: pstewart » Unassigned
Status: Active » Needs review

  • pstewart committed df3928ed on 4.3.x 
    Issue #3291464 by pstewart: Support for SQL Server specific DSN...
pstewart’s picture

pstewart commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.