Database_url syntax to connect to a local SqlLocalDB database

[htnotc]

Does anyone know the proper syntax in sqlpage.json to connect to a local SqlLocalDB database?

For now, the only workaround I have is to restore my database into an Azure SQL database from which I know how to setup a connection in sqlpage.json

Thanks in advance for your help!

[lovasoa]

Hi ! I'm not familiar with SqlLocalDb, but I think it does not allow external programs to connect to the db over tcp, as required by sqlpage.

Here are the chatgpt recommended steps to migrate to a true local sql server db.

---

1. Download the SQL Server engine (Express or Developer) and run the installer as administrator from Microsoft: https://www.microsoft.com/en-us/sql-server/sql-server-downloads

• 1. Optionally, Install SQL Server Management Studio separately from Microsoft and connect locally with Windows Authentication to confirm the Database Engine is running: https://learn.microsoft.com/en-us/ssms/install/install

2. Stop LocalDB, connect to it and back up the DB:
   BACKUP DATABASE [YourLocalDbName] TO DISK = N'C:\temp\YourLocalDbName.bak' WITH INIT;
3. Restore the backup into the new SQL Server instance (example; adjust logical names and paths):
   RESTORE FILELISTONLY FROM DISK = N'C:\temp\YourLocalDbName.bak';
RESTORE DATABASE [YourDb] FROM DISK = N'C:\temp\YourLocalDbName.bak' WITH MOVE 'LogicalMdfName' TO 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\YourDb.mdf', MOVE 'LogicalLdfName' TO 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\YourDb_log.ldf';
4. Configure SQL Server to listen on loopback only and a fixed port. Open SQL Server Configuration Manager → SQL Server Network Configuration → Protocols for → right-click TCP/IP → Properties. Set Listen All = No. On IP Addresses tab: for the 127.0.0.1 row set Enabled = Yes, TCP Dynamic Ports = (blank), TCP Port = 14330 (or your chosen port). For every other IPn row set Enabled = No. For IPAll leave TCP Port blank. Restart the SQL Server service.
5. Enable SQL authentication and create a SQL login. In SSMS set Server Properties → Security → "SQL Server and Windows Authentication mode" and restart service. Then run:
   CREATE LOGIN [my_sql_user] WITH PASSWORD = 'S3cureP@ssw0rd!';
USE [YourDb]; CREATE USER [my_sql_user] FOR LOGIN [my_sql_user]; ALTER ROLE db_owner ADD MEMBER [my_sql_user];
   Use least privileges in production.
6. For a local-only server you can use encrypt=optional

Connection string URL (credentials URL-encoded):
mssql://my_sql_user:S3cureP%40ssw0rd%21@localhost:14330/YourDb?encrypt=optional&app_name=YourSqlPageApp

Replace names, paths, password and port to match your environment.