Establish Connectivity to Microsoft SSRS
This article details how to connect to Microsoft SSRS to build Elements in Metric Insights.
PREREQUISITES:
- Specific user roles must be enabled on both SSRS UI and server side. See instructions below.
VERSION SUPPORTED:
- SSRS 2019 15.0.7243.37714
NOTE: Versions outside of this list may be supported but are not actively tested. If you have an older or newer version, please work with [email protected] so that we understand your requirements.
SSRS UI
Access <SSRShostname>/Reports/browse > Manage Folder
The service account requires the "Browser" role
SQL Server Management Studio
From Object Explorer, access the Server instance name > Security > Logins

- Create a new user
- Input a name for the user

- Under Server Roles, enable "public"
- Under User Mapping, enable "db_datareader" for the required database
1. Add New Data Source
Access Admin > Collection & Storage > Data Sources
- [+New Data Source]
- Choose "Microsoft SSRS" from the Other drop-down list
- [Next Step]
2. Provide the Required Microsoft SSRS Parameters
- Set a descriptive Data Source Name
- Provide Report Server URL for accessing the SSRS reports
- Specify the host name of the SSRS Server
- Enter Username and Plugin Password
Optionally, toggle on Enable On-Demand Element Creation
3. Specify Optional Microsoft SSRS Paremeters
Parameter | Description | |
---|---|---|
1 | Domain | Enter a domain if SSRS login requires it |
2 | Starting Folder(s) | Specify if you want to use specific SSRS folders only |
4. Advanced Configuration
Advanced Configuration settings can be set to default values unless Data Source requires more precise tuning. For more details on how to proceed, refer to Advanced Data Source Configuration.
Click [Test Connection] in the upper right corner