New Install With Remote DB / Backend URL Issues

Greetings. I just installed a fresh install of Umbraco v17 on a Windows Server 2022 machine. I want to use a remote database server (SQL Server 2022 Enterprise) so that down the road I can load balance. I installed by the documentation: dotnet new install Umbraco.Templates, dotnet new umbraco -name MyProject. Regardless of what I do, when I run install it says an SQL Lite local db has already been configured and will not let me use the remote db. I have verified connections between the two servers and they talk to each other. Along with that I am trying to change the backend URL to something besides umbraco. Below is my appsettings. What am I doing wrong?

{
“$schema”: “appsettings-schema.json”,
“Serilog”: {
“MinimumLevel”: {
“Default”: “Information”,
“Override”: {
“Microsoft”: “Warning”,
“Microsoft.Hosting.Lifetime”: “Information”,
“System”: “Warning”
}
}
},
“ConnectionStrings”: {
“umbracoDbDSN”: “Server=172.19.250.250;Database=www;User Id=wwwuser;Password=password;TrustServerCertificate=True;”,
“umbracoDbDSN_ProviderName”: “System.Data.SqlClient”
},
“Umbraco”: {
“CMS”: {
“Global”: {
“Id”: “faa5500f-a9d8-4318-919c-2b5cfa35837c”,
“SanitizeTinyMce”: true,
“UmbracoPath”: “/myPath”
},
“Database”: {
“Type”: “SqlServer”
},
“Content”: {
“AllowEditInvariantFromNonDefault”: true,
“ContentVersionCleanupPolicy”: {
“EnableCleanup”: true
}
},
“Unattended”: {
“UpgradeUnattended”: true
},
“Security”: {
“AllowConcurrentLogins”: false
}
}
}
}

You need to add the SQL server port number after the IP address of the database server. Depending on how the database server was installed, you may also have to specify an instance name.

The best way to check if you have the correct details is to try connecting with SQL Server Management Studio.

HTH,
t