CRM Reporting: Pointing at SQL AG Read Only Node RRS feed

  • Question

  • We have recently upgraded to CRM 2016 and implemented a SQL AG with SQL 2012 for the database.  Where we have run into problems is trying to point our reports at the SQL AG read only node.  When we attempt to set the connection string to point at the SQL AG listener the report throws an error that says "Expected parameter has not been supplied"

    If we point directly at the primary node it works.

    Any help or suggestions on what to look at would be greatly appreciated.



    Friday, July 22, 2016 7:03 PM

All replies

  • Correction, it works when using a data source that has this for the connection string "MSCRM DATA connector connection string"

    But does not work when we try to run the report using the shared data connector regardless of the connection string.

    Friday, July 22, 2016 7:41 PM