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();

Hi Martin,
Did continue to talk with my Agent.

Thank you, I've use Ai also, but got a different appSettings than you, and I know it could not work but I tested it, same error.

I tried of cause your appSettings.json, but it does not even make a difference if the connections string is right or wrong, same error.

{
  "ConnectionStrings": {
    "SoDatabase": "Server=APPSDEV-MKA02;Database=SUO11.10;Integrated Security=True;"
  },
  "SoDatabase": {
    "Provider": "MSSQL"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Error",
      "Microsoft": "Error",
      "SuperOffice": "Information",
      "SuperOffice.Online.Fileset.Common.MailKit.Loggers.MailKitNetCoreProtocolLogger": "Information"
    }
  },
  "SoArc": {
    "UseAzureBlobStorage": false
  }
}

Ok, strange..
Have you looked at docs here:
NetServer Core API | SuperOffice Docs

Hello everyone,

Is there a known solution to this problem? I'm getting the same error (“Missing dialect”) in a test app similar to the one described above under “Correct (minimal) C# code,” using SQL Server 2022, with all assemblies still overwritten from the SuperOffice bin directory.

P.S. 
services.AddSingleton in the example must be

Hello everyone,

I'm stuck on this problem.
I loaded all the necessary SuperOffice assemblies directly into the project references so that there would be no differences to SuperOffice compared to using NuGet.
I ran the tests on .NET 8.0, 9.0, and 10.0, and the error occurs in every version.

This is my code:

Here is my appsettings.json:

This is the error I get:

Can anyone help me?
Thanks in advance!

Best regards

Hello! 

I think you should write to SuperOffice app development

Regards Martin

Hello again. This was what I wrote when I had it working, but still needed to copy the Dll's:

string exepath = Path.GetDirectoryName(Application.ExecutablePath);
string appsettings = Path.Combine(exepath, "appsettings.json");
var config = new Microsoft.Extensions.Configuration.ConfigurationBuilder()
            .AddJsonFile(appsettings, false)
            .Build();

Services = new ServiceCollection();
Services.AddSingleton(config);
Services.AddNetServerCoreForAsyncLocalProcess(config);
Services.AddSoDatabase(config);

Provider = Services.BuildServiceProvider(true);
Provider.RegisterWithNetServer();