April 10, 20224 yr Hi Dave, I have been trying to get P2Atc to work all day. I am on Win 11 and since the upgrade from win 10 P2A isn't working anymore 😞 It seems like I also have a problem with the SQL Server. When I start P2A i get the pop-up "SQL Server": "Your SQL Server installation is either corrupt or has been tampered with (Unknown package id) I have tried all the steps you mentioned above: C:\WINDOWS\system32>SQLLocalDB delete "MSSQLLocalDB" LocalDB instance "MSSQLLocalDB" deleted. C:\WINDOWS\system32>SQLLocalDB create "MSSQLLocalDB" Creation of LocalDB instance "MSSQLLocalDB" failed because of the following error: Error occurred during LocalDB instance startup: SQL Server process failed to start. C:\WINDOWS\system32>SQLLocalDB stop "MSSQLLocalDB" LocalDB instance "MSSQLLocalDB" stopped. C:\WINDOWS\system32>SQLLocalDB create "MSSQLLocalDB" LocalDB instance "MSSQLLocalDB" created with version 15.0.2000.5. C:\WINDOWS\system32>SQLLocalDB start "MSSQLLocalDB" Start of LocalDB instance "MSSQLLocalDB" failed because of the following error: Error occurred during LocalDB instance startup: SQL Server process failed to start. As well as uninstalling P2A and the SQL server and reinstalling both. I even tried to update the SQL server to 2019 but nothing works. Any suggestions what i can do? I have tried installing everything on my laptop instead and here all is working correctly mut i don't know how to connect to my main pc... This would in any case only be a temporary fix for me... Thy in advance, Killermops Cheers, Maximilian Domann
April 11, 20224 yr Commercial Member Several users have updated from Win10 to Win11 and had to roll back to Win10, I suspect because their hardware didn't fully support all the new "features" of Win11 and so caused things like SQLLocalDB to not work. When you tried updating to SQL 2019, did you install the SQLLocalDB or the entire SQLExpress? To just install SQLLocalDB, on the first or second screen of the SQLExpress installer, there is a check box to only install SQLLocalDB. Be sure to check that box before continuing to run the installer. You'll also want to remove the SQLLocalDB 2014 that P2A installs to ensure that the newer version of SQLLocalDB is started when P2A requests the DB engine. If you did that, and it doesn't work, you may need to roll back to Win10. Dave
April 11, 20224 yr Hi again, so it turs out it has nothing todo with Win 11, anyway my pc has relatively new components... So the problem seems to be that SQL cannot run on my SSD (Samsung 980 1Tb NVMe). I have now installed SQL 2019 on my HDD and everything works now. Find the issue described here: https://docs.microsoft.com/en-us/answers/questions/541103/windows-11-unable-to-start-mssqlserver-service.html Anyway thanks for the quick reply, I much appreciate the good service! Cheers! EDIT: So apparently it worked only once ^^ so i am back to square 1 however now a couple of more SQL services seem to be running... and this is what i get now instead of the short error: Also i installed navigraph db in between runs... anyway to roll that back? Edited April 11, 20224 yr by Killermops12 Changed Circumstances Cheers, Maximilian Domann
April 11, 20224 yr Commercial Member Thanks for the update and glad you at least got it going for one shot. Edit: Changed to avoid confustion Looks like you're getting Error 50, SQL Local Database may need to be started manually. 1. Shut down Pilot2ATC 2. Open a Windows command prompt 3. Type the following command: SQLLocalDB stop "MSSQLLocalDB" 4. Type the following command: SQLLocalDB start "MSSQLLocalDB" 5. Try starting P2A again You may want to remove older versions of the SQLLocalDB to see if that allows the newer one to start automatically like it's supposed to. Dave Edited April 11, 20224 yr by Dave-Pilot2ATC
April 12, 20224 yr Hi again, so i figured it out and it's finally working reliably 😄 This is how i got it to work: 1. Uninstall everything P2A + Everything you can find called SQL on your machine 2. Install SQL Local DB 2019 (unfortunately there is no separate installer for that like with the version that comes with P2A --> You have to use normal SQL Express Server installer then select only Local DB to install) --> now critically here is to install on a drive that does not have sector storage sizes >4kb --> read more about the issue here: https://docs.microsoft.com/en-us/troubleshoot/sql/admin/troubleshoot-os-4kb-disk-sector-size (unfortunately the fix motioned doesn't solve the problem for me) 3. Install P2A and make sure to cancel the installer for SQL Express LocalDB 2014 (as you cant choose where to install it) 4. Run P2A as normal Note: if you update P2A it will try to install the localDB again so make sure to cancel it every time Cheers, Max Cheers, Maximilian Domann
April 12, 20224 yr Commercial Member Thanks for sharing the solution Max! Hopefully others will be able to use it. Dave
Archived
This topic is now archived and is closed to further replies.