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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,825 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,309 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  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.
    0 comments No comments