MSOLEDBSQL connection string with MultiSubnetFailover=true RRS feed

  • Question

  • Hi All,

    Can some one help me with MSOLEDBSQL connection string with MultiSubnetFailover=true.

    How can i create MSOLEDBSQL  linked server with MultiSubnetFailover=true.

    Help will be much appreciated and thanks in advance.



    Monday, June 24, 2019 5:20 PM

All replies

  • You would pass that condition in the @provstr argument to sp_addlinkedserver.

    Erland Sommarskog, SQL Server MVP,

    Monday, June 24, 2019 9:46 PM
  • Yes, you could refer to the format of DB2 example to add related that option to the parameter of system stored procedure sp_addlinkedserver.


    Using the Microsoft OLE DB Provider for DB2

    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Tuesday, June 25, 2019 7:12 AM