Connecting to a SQL database for a new user

[myworkaccountforsql]

Hello.

I don't really know what I'm doing, but I'm trying to make a very simple data entry form using sqlpage to enter data into an existing SQL database. Here is a picture of what the connecting screen looks like in sql server management studio to connect to the server.

My first question would be. what exactly do I type into the "sqlpage.json" file to connect to it.

[lovasoa]

Hello and welcome to SQLPage !

Create or edit sqlpage/sqlpage.json and add:

{
  "database_url": "mssql://sa:YOUR_PASSWORD@13.129.71.117/?instance=imagetrustsql"
}

What each part means:

• mssql:// — tells SQLPage you're using SQL Server
• sa:YOUR_PASSWORD@ — your username (sa) and password (replace YOUR_PASSWORD with your actual password)
• 13.129.71.117 — your server's IP address (the latest sqlpage should find the port your instance is listening on automatically)
• ?instance=imagetrustsql — the instance name from your server (13.129.71.117\imagetrustsql)

More detailed about available connection options: https://docs.rs/sqlx-oldapi/latest/sqlx_oldapi/mssql/struct.MssqlConnectOptions.html#method.from_str

If that does not work, you can rerun sqlpage while setting the env variable RUST_LOG=debug and paste the output here, that'll help figure out where your problem is.

SQLPage also supports ODBC. You can configure an odbc connection string to that database and use it both from SQLPage and from other applications.

Previous discussions about Microsoft SQL server connection options:

• Is MSSQL Database connection "integratedSecurity" option supported? #771
• Access MSSQL named instances without having to specify their port number #1082