Page Comparison

SSRS subscriptions run un-attended on the Server, which is why so the datasoruce 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 Datasources pointing to same database.
4. In SSRS URL, click on + New on the top right and select Data SoruceSource 
5. After providing an appropriate name for this datasoruceDatasource, 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 Datasource is created successfully, refer to the following article to update the report to use this new datasoruceDatasource.

Repoint SSRS report to another Datasource