Skip to main content

    Power BI

    New

    SQL Server FailOver Support Application Intent = Read Only

    Vote (38) Share
    Keith Sardone's profile image

    Keith Sardone on 09 Feb 2018 00:49:20

    Failover support has been added for AOHA SQL Server. Which is great. However, there is no option to set the Application Intent to Read Only. This routes the Connection String to the primary, placing the reporting load on primary, and leaving secondary unloaded.

    Can we have the ability to set the Application Intent to balance the server load?

    Thanks

    Comments (1)
    Keith Sardone's profile image Profile Picture

    4ac6b172 8a00-4b16-a53e-dcd425429547 on 05 Jul 2020 23:40:19

    RE: SQL Server FailOver Support Application Intent = Read Only

    Currently I use OleDb.Query instead of Sql.Database to apply "ApplicationIntent=ReadOnly".
    but It force to use authentication by password.
    I would like to use OAuth2.