Thanks, tried both of those, but no difference.
There must be a SQL script somewhere that will just set up the empty DB with appropriate login permissions. It’s hard to find out what they are.
I’m scripting it because I’m using Azure Data Studio to talk to a SQL Server 2022 in a Docker container on Linux. I’ve done this loads of times but this one isn’t working
If I change the connection string back to it’s SQLite DB (and rename the DB to the correct name) then the site just works fine. I just want to install it on a SQL Server to run a test because the SQLite DB appears to lock up after importing 100 records. Just want to make sure it’ll be ok when it’s running on the live SQL Server.