Sql Server problem on windows 11

vet mckye 0 Reputation points
Oct 10, 2024, 7:50 AM

hello guys,

I have been facing this issue on windows 11, about sql server not working.

I got a solution from here https://video2.skills-academy.com/fr-fr/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size

It was able to solve the issue, but what I'd like to do now is to apply the Trace flag ( )solution directly during sql server installation with no reboot needed. I tried everything but it's not working.

Here are the command, I used :

New-ItemProperty -Path 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL12.OPALE\MSSQLServer\Parameters' -Name 'SQLArg0' -Value '-T1800' -PropertyType String -Force

New-Item -Path 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL12.OPALE\MSSQLServer\Parameters' -Force

it's not possible through the key registry solution, because it's a mandatory to reboot to apply it.

Can anyone help me Plz !

Thank you

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,255 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,363 questions
{count} votes

Your answer

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