SQL Reporting Services with Mirrored Database, Keyword not Supported "failoverpartner"

It looks like the documentation for configuring the reporting services for Lync are wrong on the TechNet site.

The article is located here, and mentioned the connection string to be "Data source=(local)\archinst;FailoverPartner=atl-mirror-001\archinst;initial catalog=LcsCDR"

When you change the value to be the correct settings for your environment, I was getting a "Keyword not supported" error as seen below.

After a quick Google search, found an article on Doug Dietterick's Blog, Issue Deploying Lync Server 2013 Monitoring Reports to SQL Mirror.

It turned out to be that the keyword "FailoverPartner" is actually two words "Failover Partner".  Once this was updated connection was all good.


  1. Thanks for sharing this information with us. Your material is up to date and quite informative, I would like to bookmark this page so I can come here to read this again, as you have done a wonderful job.

    PIC Scheme


Post a Comment

Popular posts from this blog

Call failed due to network issue

Windows 8 Chrome and Lync 2013 Client Missed Call Notifications

AudioCodes FXO to Lync Configuration