Error starting localDb on Windows 11
9
votes
1
answer
11677
views
I installed Windows 11 on a brand new NUC, then installed all updates. Installed
Visual Studio 2022 CE
and SSMS (v 18.10)
I attempted to start the localDB which is assume was installed as part of Visual Studio 2022/ SSMS and when entering (localdb)\mssqllocaldb
in SSMS it get the error
Cannot connect to (localdb)\mssqllocaldb.
SQL Network Interfaces, error: 50 - Local Database Runtime error occurred.
Error Number: -1983577846
I then verified/attempted to start the instance as below
sqllocaldb stop mssqllocaldb
sqllocaldb delete mssqllocaldb
sqllocaldb start "MSSQLLocalDB"
When typing the last command i received the error
*Start of LocalDB instance "MSSQLLocalDB" failed because of the following error:
Cannot create an automatic instance. See the Windows Application event log for error details.*
I looked at the log file found under
*....\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB*
and see a few error files and select the most latest one by date.
It contains info and the last line is
2021-12-11 10:48:42.67 spid10s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Users\....\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB\master.mdf.
The file is pretty short but i dont see an entry with **Error** anywhere and most lines end with *This is an informational message; no user action is required.*
**Windows log states**
*Windows API call WaitForMultipleObjects returned error code: 575. Windows system error message is: {Application Error}
The application was unable to start correctly (0x%lx). Click OK to close the application.
Reported at line: 3714.*
Opened up services and can see SQL Services VSS Writer with status of running and no other SQL service.
Does anyone have any recommendations for me to try?
Asked by Computer
(193 rep)
Dec 11, 2021, 11:13 AM
Last activity: Feb 19, 2022, 08:51 AM
Last activity: Feb 19, 2022, 08:51 AM