I have the database error. My PC is 3 month old. Win 11. Xplane on D, Pilot2ATC on E. I installed the latest version pilot2 ATC as admin.

First i made the normal installation with SQL14. Then i desinstalled this and downloaded and installed as admin SQL 15 (2019). The SQL is in the c:\program files\Microsoft SQL Server.

But in C:\Users\shage\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB I find files from 2014.

I made the next steps

3.    Add the following registry key using Powershell 

• New-Item -Path 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15E.LOCALDB\MSSQLServer\Parameters' -Force
• New-ItemProperty -Path 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15E.LOCALDB\MSSQLServer\Parameters' -Name 'SQLArg0' -Value "-T1800" -PropertyType String -Force

 

4.    Then execute these commands at a Command Prompt:

• sqllocaldb stop MSSQLLocalDB
• sqllocaldb delete MSSQLLocalDB

Step 4 , i got the message, File is not there or wrong written

This is the logfile

Program StartedPilot2ATC® (P2A) - version 2.6.4.2_x64  02/10/2024 10:05:05
Windows OS: Microsoft Windows 11 Home
Version: 6.2.9200.0
Platform: Win32NT
Memory: 33513893888

Trying to create DB_Dyno.
DB_Dyno created successfully.
Error in FlightData Init
System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Netzwerkbezogener oder instanzspezifischer Fehler beim Herstellen einer Verbindung mit SQL Server. Der Server wurde nicht gefunden, oder auf ihn kann nicht zugegriffen werden. Überprüfen Sie, ob der Instanzname richtig ist und ob SQL Server Remoteverbindungen zulässt. (provider: SQL Network Interfaces, error: 52 - Es konnte keine Installation der Local Database Runtime gefunden werden. Überprüfen Sie, ob SQL Server Express richtig installiert und die Funktion Local Database Runtime aktiviert ist.) ---> System.ComponentModel.Win32Exception: Das System kann die angegebene Datei nicht finden
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
   bei System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   bei System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   bei System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   bei System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   bei System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   bei System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   bei System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   bei System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   bei System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   bei System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   bei System.Data.SqlClient.SqlConnection.Open()
   bei System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   bei System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)
   bei System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass2_0.<Execute>b__0()
   bei System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   bei System.Data.Entity.Core.EntityClient.EntityConnection.Open()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei System.Data.Entity.Core.EntityClient.EntityConnection.Open()
   bei System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions)
   bei System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   bei System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass41_0.<GetResults>b__0()
   bei System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   bei System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   bei System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__31_0()
   bei System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   bei P2A2021.FlightData.Init()
Application frmP2AMain starting 02/10/2024 10:07:21
Loading Joystick Devices - 2 devices loaded.
Loading Form
Main form opened: Pilot2ATC® 2021 v. 2.6.4.2_x64      Navigraph - AIRAC cycle: 2401
Loading Joystick Devices - 2 devices loaded.
Loading Joystick Devices - 2 devices loaded.
Loading Joystick Devices - 2 devices loaded.
Loading Joystick Devices - 2 devices loaded.
Joystick Device number 0 successfully activated.
Loading Map Control
LoadMapControl: panel 1
Creating ucMap1
SQLiteVersion: 3.8.11.1 | 2015-07-29 20:00:57 cf538e2783e468bbc25e7cb2a9ee64d3e0e80b2f | INTEROP_CODEC INTEROP_EXTENSION_FUNCTIONS INTEROP_VIRTUAL_TABLE NET_40 PRELOAD_NATIVE_LIBRARY THROW_ON_DISPOSED TRACE TRACE_PRELOAD TRACE_SHARED TRACE_WARNING USE_PREPARE_V2 WINDOWS
ucMap1 Created
ucMap DockFill set.
Setting Map Mode
Done Loading Map Control
Loading FPL Control
FPL Control Loaded
Retrieving TAF from web failed at 02/10/2024 10:07:23
Retrieving weather from web failed at 02/10/2024 10:07:23
Simulator Disconnected. 02/10/2024 10:07:32
Application frmP2AMain ended normally 02/10/2024 10:07:36

For a new Windows 11 PC, you shouldn't need the Powershell Registry entries.  You just:

Uninstall the SQLLocalDB 2014 using Windows Control Panel->Programs and Features.

Then install SQLLocalDB 2019.  Not SQL Express 2019.  You can select to install SQLLocalDB from the SQL Express installer by choosing the  option to extract LocalDB.

REBOOT the PC.

Then execute these commands at a Command Prompt:
⦁    sqllocaldb stop MSSQLLocalDB
⦁    sqllocaldb delete MSSQLLocalDB

REBOOT the PC

then execute these commands:
⦁    sqllocaldb create MSSQLLocalDB
⦁    sqllocaldb start MSSQLLocalDB

REBOOT the PC

It works. But the commands didn't work 🙂  I only installed the localDB and copied some localDB files from another PC  in the local..windows folder. In the moment, no more problems. A ltlle bit strange