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;
These keys are required for the Enterprise BI Portal to function correctly. They must be entered during the application installation.
|ClientId||This is the Application ID of the App Registration generated during Identity Server app registration.|
|ClientSecret||This is the Client Secret generated during Identity Server app registration.|
|PostLogoutRedirectUri||This is the URL to redirect to after a logout. It is the URL of the web application followed by /Account/SignOutCallback (Ex. https://portal.my.domain/Account/SignOutCallback).|
|Authority||This is the URL of your Identity Server, followed by :443/ (Ex. https://identity.my.domain:443/)|
|RedirectUri||This is the URL of your BI Portal, followed by a trailing forward slash. (Ex. https://portal.my.domain/).|
|BiPortalDb||This is a SQL connection string for your web application. Please refer to SQL Connection String Format when entering this value.|
|BiPortalDb_DatabasePublish||This is a SQL connection string for your web application. Please refer to SQL Connection String Format when entering this value.|
|Client Name||This is a display name to identify the client configuration. (Ex. Enterprise BI Portal)|
|Client Uri||This is the URL of your web application followed by a trailing forward slash. (Ex. https://portal.my.domain/)|
|Post Logout Redirect Uri||This is the URL to redirect to after a logout from your BI Portal. It is the URL of the web application followed by /Account/SignOutCallback (Ex. https://portal.my.domain/Account/SignOutCallback)|
|Redirect Uris||Add the following five redirect Uris, replacing portal.my.domain with your own DNS name for the portal https://portal.my.domain/