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