Unable to run reports: Cannot create a connection to data source 'SaaS'. (rsErrorOpeningConnection)

Version 1

    Details

    When trying to run a report an error is returned: 


    An error has occurred during report processing. (rsProcessingAborted)
    Cannot create a connection to data source 'SaaS'. (rsErrorOpeningConnection)
    Format of the initialization string does not conform to specification starting at index 67.

     


    Resolution

     

    This error can be returned if the password used for the Report Credentials in the SaaSDS Datasource contains a single quote character: '

    The single quotes do not get escaped correctly by Microsoft SQL Reporting Services so causes an error with the Connection String that is generated to connect to the database.

    Use a password without single quotes.