Difficaulty linking existing database.

[RayneRed13]

I've been trying to link my existing database.

These are the settings. What do I have to put in the json file?

[lovasoa]

Your connection dialog uses Windows Authentication, but SQLPage's MSSQL driver (sqlx) only supports SQL Server Authentication — there's no integrated/NTLM support. So
you first need a SQL login (e.g. sa or a dedicated user) with a password.

Then sqlpage/sqlpage.json would look like:

  {
    "database_url": "mssql://myuser:mypassword@localhost/mydatabase?instance=SQLEXPRESS&encrypt=mandatory&trust_server_certificate=true"
  }

Otherwise, you can use odbc :

  {
    "database_url": "Driver={ODBC Driver 18 for SQL Server};Server=localhost\\SQLEXPRESS;Database=sqlpage;Trusted_Connection=yes;Encrypt=yes;TrustServerCertificate=yes"
  }

You can find the driver name with

  reg query "HKLM\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers"