So we are moving to have multisubnet SQL clusters. And I know that when you do so, you have to specify "MultiSubnetFailover=True" in the "Additional Connection Parameters" , when you connect to a SQL server using SQL Server Management Studio,
But how do you make that a default entry for *all* connections? I've seen references on how you can specify that as part of an ODBC connection string, but I'm not doing that. I'm just bringing up the Management Studio and connecting to various and sundry database servers. And I don't want to forget to type that in, each time I open a connection. I haven't found a way to do that, am I just searching wrong, or missing something obvious?
