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.

Generic reporting account

1. Please contact TSM SaaS Support, to create a generic Reporting account, as additional setup will be required to configure the non-expiring password.

Configure the Subscription Datasource

1. Refer to site report for Database Server name, this is usually listed as CNAME. 
2. Replace <server_name> and <database_name> in the following template to build the connection string:
   • Data Source=<server_name>;Initial Catalog=<database_name>
3. Alternatively, the connection string can also be copied from other Datasources pointing to same database.
4. In SSRS URL, click on + New on the top right and select Data Source 
5. After providing an appropriate name for this Datasource, paste the connection string from Step 2 in the Connection string textbox 
6. Under Credential section, select Using the following credentials
7. Select Database user name and password from Type of credentials dropdown
8. Please paste the credentials of generic reporting account.
9. 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