Monday, 2 September 2013

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 comment:

  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


MoH - Skype, AudioCodes and an SIP Carrier

Troubleshooting an MoH issue today, where a SfB client would places a PSTN caller on hold, and the PSTN caller would get no MoH.   SBC con...