Configure Datasource for subscriptions in SSRS

Need Datasource configured for Subscriptions in SSRS

• SSRS Reports
• Munis All Versions
• Tyler, SaaS Hosted Clients

Reports using default Datasource doesn't allow creation of Subscriptions

SSRS subscriptions run un-attended on the Server, so the Datasource of the report should have credentials of a generic reporting account stored. If one such account does not exist, please see the following article to first create a generic account:

Create generic reporting account - SaaS

Configure the subscription datasource:

1. Copy the connection string from an existing datasource.
2. In SSRS URL, click on + New on the top right and select Data Source 
3. After providing an appropriate name for this datasource, paste the connection string from Step 1 in the Connection string textbox 
4. Under Credential section, select Using the following credentials
5. Select Database user name and password from Type of credentials dropdown
6. Please paste the credentials of generic reporting account.
7. Click Create

Once Subscription datasource is created successfully, refer to the following article to update the report to use this new datasource.

Repoint SSRS report to another datasource