Configure SSRS datasource for OnPrem clients

User needs SSRS shared datasource to create custom reports

• SSRS

• Self-hosted, OnPrem clients

• Database connection

SSRS shared datasource is needed to create custom reports

The following steps illustrate how to create a SSRS datasource

1. Refer to site report for Database Server name. 

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. In SSRS URL, click on + New on the top right and select Data Source 

4. After providing an appropriate name for this datasource, paste the connection string from Step 2 in the Connection string textbox 

5. Under Credential section, select As a user viewing the report

6. Click Apply