Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Thanks

    Jim

    Friday, July 22, 2016 7:03 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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