Category / Section
Resolve Database Configuration Setup Issue | Bold BI
Published:
This article explains about how to check and resolve the database configuration setup issue in the Bold BI Embedded Analytics Server. Database is used to store the information like users, resources (dashboards, data source,...) and their permissions. For more details about database configuration, please refer to below document:
https://help.boldbi.com/application-startup/latest/#database-configuration
If any errors occur during its setup, respective error detail is shown in the error message and you can check and resolve the possible errors like not able connect the SQL Server due credential mismatch or not able to reach the server, also you can create tickets by sharing error details screenshot to address the issue by Bold BI team.
https://help.boldbi.com/application-startup/latest/#database-configuration
If any errors occur during its setup, respective error detail is shown in the error message and you can check and resolve the possible errors like not able connect the SQL Server due credential mismatch or not able to reach the server, also you can create tickets by sharing error details screenshot to address the issue by Bold BI team.
How to find the error of database configuration
- Once provided the database details, click on Next. Now it would try to connect to the database if any error occurred error text will be shown as mentioned in below step.
- Click on 'here', and you can see the reason for the failure in the popup dialog.
- Error message will be shown like below:
Note
The credentials used to connect to the server instance must have the permissions specified here.
Possible connection failures of SQL Server
- Check Server Availability: Ensure that the SQL Server is running and accessible. Verify the server's availability and that it is reachable from the network.
- Remote Connections Configuration: Ensure that SQL Server is configured to allow remote connections. You can check this in the SQL Server Configuration Manager. Look for the SQL Server Network Configuration section and verify that TCP/IP and Named Pipes are enabled.
- Firewall Settings: Check the firewall settings on both the client and server machines. Ensure that the SQL Server port (default is 1433) is open and allowed through the firewall.
- SQL Server Browser Service: If you are using named instances, make sure the SQL Server Browser service is running. This service helps in identifying and connecting to named instances.
- Connection String: Review your connection string to make sure it accurately reflects the SQL Server configuration. Pay attention to the server's name, instance name, and authentication details.
- SQL Server Logs: Check the SQL Server error logs for additional details. Look for any entries related to failed connection attempts, and this may provide more insight into the issue.
- Network Troubleshooting: Perform general network troubleshooting. Check for any network issues and ensure that there are no network-related problems preventing communication with the SQL Server.
- Connection Timeout: Make sure that there is no connection timeout during establishment, if so, provide connection timeout parameter under the Additional Parameters field based on the SQL Server type you are connecting.
General SQL Troubleshooting
Details required when contacting Bold BI Support
If the issue is still not resolved, then please create a support ticket using this link and share below details for issue investigation.
- Screenshot of the error which is mentioned in step 3 of above "How to find the error message in the database configuration" section.
- Bold BI application logs by referring below KB article,
Where Can I Manually Find the Logs for the Bold BI Application on Different Environments
NM
