search

lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly
https://sql.datapage.app
MIT License
1.29k stars 69 forks source link

SQL Server named instance database_url #92

Closed spiralcb closed 11 months ago

spiralcb commented 11 months ago

Hello,

Very fun project, I'm trying it using SQL Server.

Could you give me an example of database_url for a SQL Server named instance with user and password please ?

Thanks in advance

lovasoa commented 11 months ago

Hello and welcome to SQLPage !

Currently, SQLPage requires you to manually enter the port your database is listening on when connecting to a named sql server instance. See: https://github.com/lovasoa/SQLpage/issues/86

An example connection string would be mssql://username:password@localhost:2179/YourDatabaseName?instance=YourInstanceName, where you would replace 2179 with the port your instance is listening on, which you can find in the SQL Server configuration manager.

spiralcb commented 11 months ago

Thanks a lot, it wroks