---
title: "Connect Bolt.new to an On-Prem SQL Server | DreamFactory"
description: "Bolt.new can build the application, but it cannot reach a SQL Server sitting inside your network — and the usual workarounds are opening a firewall port or…"
url: "https://www.dreamfactory.com/videos/connect-bolt-to-on-prem-sql-server"
---

[Home](https://www.dreamfactory.com/) › [Videos](https://www.dreamfactory.com/videos) › Connect Bolt.new to an On-Prem SQL Server

# Connect Bolt.new to an On-Prem SQL Server

Video·13 October 2026·8 min 56 sec

Bolt.new can build the application, but it cannot reach a SQL Server sitting inside your network — and the usual workarounds are opening a firewall port or pasting the database password into the project. This build does neither. DreamFactory sits in front of the database, generates a REST API, and restricts it to a read-only role and a scoped API key; Bolt then calls that API from a Bolt server function to produce a live delivery operations dashboard.

## What you’ll learn

* Why Bolt.new cannot open a direct connection to an on-prem SQL Server
* Generating a REST API over that database and scoping it read-only
* Calling the API from a Bolt server function instead of the browser
* Building a delivery operations dashboard against live on-prem data

## Frequently asked questions

### Can Bolt.new connect to an on-premise database?

Not directly — a Bolt project cannot open a database connection into a private network. It can call an HTTPS API, so the working pattern is to put a REST API in front of the database and have Bolt call that. In this video DreamFactory generates that API and Bolt consumes it from a server function.

### Do I have to open a firewall port for Bolt.new to reach SQL Server?

No. The database stays closed to inbound traffic. DreamFactory is what holds the database connection, and Bolt only ever talks to the REST API over HTTPS with an API key, so no port is opened on the SQL Server itself.

### Does Bolt.new ever see my SQL Server password?

No. The database credential is held by DreamFactory and never leaves it. Bolt receives only a scoped API key bound to a read-only role, so the most that key can do is read the tables that role permits.

[Book a Demo](https://www.dreamfactory.com/demo)[More on our YouTube channel](https://www.youtube.com/@DreamfactoryAPI)

## More videos

* [Connect Replit to an On-Prem SQL Server](https://www.dreamfactory.com/videos/connect-replit-to-on-prem-sql-server)
* [Connect Google AI Studio to an On-Prem SQL Server](https://www.dreamfactory.com/videos/connect-ai-studio-to-on-prem-sql-server)
* [Connect Lovable to an On-Prem Database](https://www.dreamfactory.com/videos/connect-lovable-to-on-prem-sql-server)
* [Connect Base44 to an On-Prem Database](https://www.dreamfactory.com/videos/connect-base44-to-on-prem-database)

[Browse all videos ›](https://www.dreamfactory.com/videos)

Video: https://www.youtube.com/watch?v=ZSLrunJik-M