Configure SSRS datasource for OnPrem clients

Owned by Knowledge Assistant
Oct 21, 2022
1 min read



Description of Issue

User needs SSRS shared datasource to create custom reports



Context

  • SSRS

  • Self-hosted, OnPrem clients

  • Database connection



Cause

SSRS shared datasource is needed to create custom reports



Resolution

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



Additional Information