Sql Server problem on windows 11
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