Share via

Problem with SQL local server on windows 11

Paul S 5 Reputation points
2023-01-19T19:49:47.3066667+00:00

2023-01-19_19h56_45

I tried to install SQL Server 2022 today and ran into a problem. I couldn't not finish the installation from GUI setup. After a little bit of research I found out my SSD runs with 16kb sectors of storage and that SQL only handles 4, used the microsoft commands to force SQL to use 4kb sectors. At this point things ran normally, could create local SQL servs locally and start them. I then rebooted and got this, I can now no longer any SQL servers or even display information, I can't start the service in services.msc either (and can't get rid of the SQL server 2022 express version, it gets stuck at Cpu64 and I have to reboot). Would like to avoid reinstalling system if it's doable and fix this as I need SQL DBs for work on my personal machine, any help much appreciated.

Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Paul S 5 Reputation points
    2023-01-19T20:54:53.2366667+00:00

    Hello, I fixed my problem. I had removed inadvertently SQLlocalDB 2019 which VStudio uses when I uninstall SQl Server 2019 via its own GUI. Reinstalling SQLlocalDB 2019 fixed this.

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.