Error: Cannot create a connection to data source 'MainDataSource'., when running reports within the Compliance Portal.
Make sure the corresponding datasource has been configured with the proper syntax (without the <> around the database name)
To connect a data source to the corresponding product server and database, perform the following steps:
1. Click Data Sources in the left pane and select the desired data source.
2. Select the Data Source Properties option in the right pane. The Microsoft Reporting Services Data Source Properties page is displayed.
3. Edit the default placeholder for the Connection String.
4. Click Apply to save your changes and then Back to return to Compliance Portal.