Configure Live Builder Datasource in SSRS

Need to configure Live_Builder Datasource

Need connection to Production database server

Setup Datasource in SSRS for Production environment

Setup Datasource for building Custom SSRS Reports

• SSRS Reports
• Munis All Versions
• Tyler, SaaS Hosted Clients

Need Live_Builder Datasource to build Custom SSRS Reports

The following steps illustrate how to setup a Live_Builder Datasource

1. Refer to site report for Database Server name, this is usually listed as CNAME. 
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 By prompting the user viewing the report for credentials
6. Select Database user name and password from Type of credentials dropdown
7. Click Apply

A reporting account is necessary to run any report using this Datasource. Refer to the following article on how to create a reporting account.

Munis Cloud Admin Reporting Accounts