Configure Datasoruce for subscriptions in SSRS

Need datasoruce 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, which is why the datasoruce 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 Soruce 
5. After providing an appropriate name for this datasoruce, 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 datasoruce is created successfully, refer to the following article to update the report to use this new datasoruce.

Repoint SSRS report to another Datasource