Page Comparison

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

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