Add support for Windows Authentication to SQL Server

[rcwombat]

What are you building with SQLPage ?
Dashboards and tools for Point of Sales systems

What is your problem ? A description of the problem, not the solution you are proposing.
Currently SQLPage does not support SQL Server database connections via Windows Authentication (integratedSecurity).
Attempts to use results in:

[2025-01-12T00:58:50.118Z ERROR sqlpage] "mssql://localhost/{DBNAME}?instance={NAMEDINSTANCE}&integratedSecurity=true" is not a valid database URL. Please change the "database_url" option in the configuration file.

    Caused by:
        0: error with configuration: `integratedSecurity` is not a valid mssql connection option
        1: `integratedSecurity` is not a valid mssql connection option

What are you currently doing ? Since your solution is not implemented in SQLPage currently, what are you doing instead ?
Creating user/password...

Describe the solution you'd like
Add support for connection string to handle Windows Authentication.

Additional context
Add any other context or screenshots about the feature request here.

[kryskool]

Hi @rcwombat

By experience, it's bad designn to use Windows or Active Directory authentication for a database, i prefer to create a specific user to prevent password policy changes for example.

Regards,

[rcwombat]

Hi @kryskool,

By experience, it's not always your database that you need to connect so you don't get a say in how someone else has designed any part of it.