Post reply

SSRS - Connecting to the readable secondary with SSRS

  • December 21, 2014 at 4:05 pm

    #299588

    Hi Guys

    I have been working with a BI colleague to access the readable secondary through SSRS. For some reason it keeps complaining that ApplicationIntent is not recognized keyword. I am starting to think it's something to do with the driver for SSRS.

    If any of you have connected to the readable secondary using SSRS , will you please share the connection string and also tell me the version of the driver used by SSRS.

    Thanks

    Jude

  • December 21, 2014 at 11:50 pm

    #1765911

    Dear Jude,

    The message occurs when you include ApplicationIntent=ReadOnly (AlwaysOn Availability Groups properties) in your connection string. And the server does not recognize the property.

    To resolve this issue you will have to install the hotfix/update that introduce support for AlwaysOn feature from SQL Server 2012.

    You can download the update from here.

    # http://support.microsoft.com/kb/2654347

    Hope it helps...!!!

    Regards

    Shafat Husain

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply