How do we add multisubnetfailover=true to multiscript?

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.
Tagged:

Answers

  • 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.

  • IAmNotAMothIAmNotAMoth Posts: 2 New member
    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
Sign In or Register to comment.