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.

[lovasoa]

Hi! The good news is that since 0.38 we support odbc. You can connect to your mssql instance through odbc and use windows auth!

Older issue on the same topic: https://github.com/sqlpage/SQLPage/issues/75