Authentication failed

Thank you for your help, but where do I download 11.12.675.0?

I actually looked at this and thought that SQL 22 was OK

But then this means that only up to 10.1.6 has been tested?

Tested with MSSQL 2019, and gets the same error: SoException: Missing dialect for database Major: 'MSSQL', Minor: '15'.

It is my own exe-app. The SoAppConfig works.

This is my test code that fails with error.

string fullPath = Path.Combine(ExePath, "appsettings.json");
            
IConfigurationRoot implementationInstance = new Microsoft.Extensions.Configuration.ConfigurationBuilder().AddJsonFile(fullPath).Build();

Startup startup = new Startup((IConfiguration)implementationInstance);
ServiceCollection services = new ServiceCollection();

services.AddSingleton((IConfiguration)implementationInstance);
//services.AddNetServerCoreForAsyncLocalProcess((IConfiguration)implementationInstance);
//services.AddSoDatabase((IConfiguration)implementationInstance);
startup.ConfigureServices((IServiceCollection)services);
startup.Configure((IServiceProvider)services.BuildServiceProvider());

string serial = SoDatabase.GetCurrent().SerialNumber;

Ok, something must be wrong there then. (changes made in newer SO 11.x versions).  For what vesion are  u sure the above code works?
If I continue to ask my AI it say:

======================================

Här är en kort och forum‑anpassad sammanfattning, med fokus på lösningen i koden:

Missing dialect (MSSQL 16) i custom console‑app – lösning

Felet beror oftast inte på SQL Server, utan på att NetServer inte är korrekt initialiserad i en command‑line‑applikation.

I en console‑app måste NetServer och SoDatabase explicit registreras. Till skillnad från Web/Win‑klienter sker detta inte automatiskt.

Vanliga orsaker

• AddNetServerCore… och/eller AddSoDatabase är inte registrerade
• RegisterWithNetServer() saknas
• Felaktig eller ofullständig appsettings.json
• Appen refererar äldre NetServer‑DLL:er utan MSSQL‑16‑dialekt

✅ Rekommenderad minimal lösning i kod

var config = new ConfigurationBuilder()

    .AddJsonFile("appsettings.json", false)

    .Build();

var services = new ServiceCollection();

services.AddSingleton

services.AddNetServerCoreForAsyncLocalProcess(config);

services.AddSoDatabase(config);

var provider = services.BuildServiceProvider();

provider.RegisterWithNetServer();

var serial = SoDatabase.GetCurrent().SerialNumber;

Viktigt

• Säkerställ att appsettings.json innehåller full SuperOffice‑konfiguration
• Kontrollera att DLL‑versionerna matchar serverns SuperOffice‑build
• Annars saknas MSSQL‑16‑dialekten → Missing dialect for database Major: MSSQL, Minor: 16

Kort sagt:

Detta är ett bootstrap/DI‑problem i custom‑koden, inte ett SQL‑problem.

============================
OBS, kan ju vara fel så klart...har inte någon miljö (ännu) där jag själv kan testa detta.

//Anders 

Thank you! Stil the same error.

In appSettings.json, what is a full SuperOffice configuration, where can I see it?

{
  "Logging": {
    "LogLevel": {
      "Default": "Error",
      "Microsoft": "Error",
      "SuperOffice": "Error",
      "SuperOffice.Online.Fileset.Common.MailKit.Loggers.MailKitNetCoreProtocolLogger": "Information"
    }
  },
  "SoArc": {
    "UseAzureBlobStorage": false
  }
}

I still can't get it to run, I started from zero again, with a small Net 10.0 Console app. Maybe someone want to test it themself: https://download.beezy365apps.com/Com/SuperOfficeConsole.zip

I am not sure about the appSettings.json, but if needed it is the in the solution folder.

This is the code (all of it):

using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using SuperOffice;
using SuperOffice.Data;

var ExePath = Path.GetDirectoryName(System.Environment.ProcessPath);
string appsettings = Path.Combine(ExePath, "appsettings.json");
var config = new Microsoft.Extensions.Configuration.ConfigurationBuilder()
    //.AddJsonFile(appsettings, false)
.Build();

var services = new ServiceCollection();
services.AddSingleton(config);
services.AddNetServerCoreForAsyncLocalProcess(config, (Action)(options => { }));
services.AddSoDatabase(config);
//services.AddSingleton();

var provider = services.BuildServiceProvider();
provider.RegisterWithNetServer();

using var session = SoSession.Authenticate("MA", "ma");
var serial = SoDatabase.GetCurrent().SerialNumber;
Console.WriteLine(serial);

Console.ReadLine();