How do we add multisubnetfailover=true to multiscript?

IAmNotAMoth

Hi Guys,

What the title says. We have to add that to our connection strings in order to make things work. I can't find a place to add that in multiscript, so we're getting intermittent failures. Any ideas?

Thanks.

ATurner

Hi IAmNotAMoth

In theory you may well be able to get this working via: Clicking 'Configure...' on the Database Distribution List on the right-hand side, then 'Add a SQL Server not listed', then use the server name and a semicolon and then the property MultiSubnetFailover=True.

For example \\servername;MultiSubnetFailover=True

Please let me know if this still fails.

IAmNotAMoth

That did not work. It said the instance was not valid. 

For reference, we're having to use this:  INSTANCE.db.prod.3pl.local\INSTANCE;MultiSubnetFailover=True