use multisubnetfailover in v7

[kalpaj12]

How do I enable multisubnetfailover in v7. I did find a sample code for previous version but this configuration does not work in v7.

Expected behaviour:

Since I have an AGL to prod servers, I need to enable multisubnetfailover, if not, connection fails.

Actual behaviour:

Connection to AGL fails.

Configuration:

{
    "server": "agl.example.com",
    "database": "DB",
    "user": "user",
    "password": "pwd",
    "connectionTimeout": 0,
    "requestTimeout": 0,
    "stream": false,
    "pool": { "max": 10, "min": 0, "idleTimeoutMillis": 30000 },
    "options": {
      "enableArithAbort": true,
      "encrypt": true,
      "trustServerCertificate": true
    }
  }

Software versions

• NodeJS: v16.13.0
• node-mssql: v7.3.0
• SQL Server: 2019

[dhensby]

Adding it to the options should work, as these are passed straight through to the tedious driver.

{
    "server": "agl.example.com",
    "database": "DB",
    "user": "user",
    "password": "pwd",
    "connectionTimeout": 0,
    "requestTimeout": 0,
    "stream": false,
    "pool": { "max": 10, "min": 0, "idleTimeoutMillis": 30000 },
    "options": {
      "enableArithAbort": true,
      "encrypt": true,
+     "multiSubnetFailover": true,
      "trustServerCertificate": true
    }
  }

What is "not working" about it at the moment (any meaningful error)?

[kalpaj12]

Uhm, I must have missed something last time, this works now, thank you @dhensby! :)