/
Configure SSRS datasource for OnPrem clients

Configure SSRS datasource for OnPrem clients



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












Related content

Configure datasource for subscriptions in SSRS for OnPrem clients
Configure datasource for subscriptions in SSRS for OnPrem clients
More like this
Configure Live Builder Datasource in SSRS
Configure Live Builder Datasource in SSRS
More like this
Configure Datasource for subscriptions in SSRS
Configure Datasource for subscriptions in SSRS
More like this
How to create email subscription for a custom SSRS report for OnPrem clients
How to create email subscription for a custom SSRS report for OnPrem clients
More like this
Repoint SSRS report to another datasource
Repoint SSRS report to another datasource
More like this
Custom reporting through TID SSRS
Custom reporting through TID SSRS
More like this