Appendix

SQL Connection String Format

The connection string format shown below is to be used with the Enterprise BI Portal. You will need to replace a few pieces of information within the connection string;

  • Server FQDN – This is the fully qualified domain name of the SQL server where your database is hosted
  • Database Name – The name of the database used during the database creation process

Ensure you remove the <> values from the string, these are just to highlight tokenized parts of the connection string.

Server=<Server FQDN>;Initial Catalog=<Database Name>;Integrated Security=true;TrustServerCertificate=True;Pooling=False;MultipleActiveResultSets=False;Encrypt=True;Connection Timeout=30;

Web Application Settings

These keys are required for the Enterprise BI Portal to function correctly. They must be entered during the application installation as per the below descriptions.

Base Url
This should be the full URL of your website, including the port number :443, followed by a trailing forward slash. (Ex. https://identity.my.domain:443/)

Database Connection String
This is a SQL connection string for your web application. Please refer to SQL Connection String Format when entering this value.

Permissions to the Identity Server configuration site

To manage the Identity Server client list, you must be a member of the local administrators group on the server hosting the website.