Multi-subnet SQL Always on Group
Our RDM SQL Database was recently moved to a Multi-Subnet SQL Always on Group. We're seeing random timeouts when connecting to the database listener. Our DBA team has said that we need to add multisubnetfailover=true to our connection information, howerver I don't see a way to do this. My guess is this is something that needs to be added to the Advanced Settings under the SQL Connection, but I thought I would check to make sure I'm not missing it before opening a feature request.
All Comments (2)
Hello,
In the data source settings (File - Data sources), the advanced tab has an Advanced Settings button which exposes the "well known" settings of the Connection String. Although you cannot add a new one, you can simply type over one which isnt used.
Could you try adding it? I first added gibberish and it complained that the value was not supported, then added multisubnetfailover and it didnt complain. It would indicate that it understands it.
Best regards,
Maurice
2018-10-10_13-58-40.png
Thanks. It wasn't terribly clear that I could modify those existing parameters to create new ones. I've modified the clustering Failover Partner with this value and set it to true. At best I can say it didn't break anything at the moment. We also discovered it may be an issue with our software defined perimeter. I'm running down with that vendor. My utility server inside the perimeter appears to be working well now.