Does SQL Server need to be publicly accessible to connect with Bold BI?

When integrating SQL Server with Bold BI, it is important to understand the accessibility requirements based on the deployment type of Bold BI.

On-Premises Version

For the self-hosted on-premises version of Bold BI, SQL Server doesn’t need to be publicly accessible. The only requirement is that the SQL Server must be accessible from the machine where Bold BI is installed. This ensures that the application can connect to the database without exposing it to the public internet.

Cloud-Based Version

In the case of the cloud-based version of Bold BI, specific configurations are necessary to establish a connection with SQL Server. The database server must be configured to whitelist certain IP addresses associated with the Bold BI cloud servers. This is crucial for creating the data source successfully.

To facilitate this process, a comprehensive list of the required IP addresses can be found in the following documentation:

Whitelisting IP Addresses for Bold BI Cloud

Conclusion

In summary, while the on-premises version of Bold BI does not require SQL Server to be publicly accessible, the cloud-based version necessitates specific IP whitelisting to ensure proper connectivity.