How can we help you today? How can we help you today?

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.
Scott
0

Comments

2 comments

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

    ATurner
    0
  • 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
    IAmNotAMoth
    0

Add comment

Please sign in to leave a comment.