really thanks bro.. its works , i had been seeing things on internet to solve the issue like 3 hours until see this video...really I'm blissful to your videos...keep it up bro
Brother, I wholeheartedly thank you for this video. I have been stuck on this for 4 days and tried everything, from changing registry files to renaming server names to even resetting my pc TWICE! I have a project to do which required this, so truly appreciate the help. MS should have provided this solution earlier, but ok , nvm, have a good day.
Man really grateful for this video...i have been crawling over all the documentation and yep i read this one too but as a new develpor didn't exactly knew what to do. this video made my day and really solved the problem Thank you so much man
I just want to say thank you, I really appreciate this video, I was struggling for months for this issue and this finally was the real solution, keep doing videos men, your explanations are great and clear. Regards from Chile !
@@vaibhavkumar5512 I haven't changed back my settings, it has been working fine for me in terms of speed. However, I will research and find out. Cheers!
Brooooooo game tricks brooooo , finally problem solved , thank you so much, lots of love . If this problem would have not fixed , I am about to quit leaning SQL . Once again gametrick brooooo thank you so much!
The solution did really work on my Windows 11. This is the error log: Feature: Database Engine Services Status: Failed Reason for failure: An error occurred during the setup process of the feature. Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Component name: SQL Server Database Engine Services Instance Features Component error code: 0x851A001A Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. I fixed the problem after 5 days of crying! Thank you.
Thank you very much I could finally install the sql server but does it affect the pc in anyway if we change the physical sector bytes? Also is there a way to revert back to the default bytes it used to display? I got no clue if this could cause me trouble in future so I'm looking forward for your response. Thank you
Very helpful , you save me. Many thank to you. But i have a little question, after successfully install sql server 2022, do i need to undo what i did in Registry Editor(delete the multi string ForcedPhysicalSectorSizeInBytes)? Thankyou alot.
Hi @Sunand Pal, Thank you for the details. In my system 'PhysicalbytespersectorforAtomicity is 512' and when I am adding ForcedPhysicalSectorBytes the issue is still the same. Can you please help me out here?
Thank you for the details. In my system 'PhysicalbytespersectorforAtomicity is 512' C:\Windows\System32>fsutil fsinfo sectorinfo C: LogicalBytesPerSector : 512 PhysicalBytesPerSectorForAtomicity : 512 PhysicalBytesPerSectorForPerformance : 512 FileSystemEffectivePhysicalBytesPerSectorForAtomicity : 512 Device Alignment : Aligned (0x000) Partition alignment on device : Aligned (0x000) No Seek Penalty Trim Supported Not DAX capable Not Thinly-Provisioned after adding ForcedPhysicalSectorBytes and restart my PC the issue is still the same. Can you please help me out here?
@@sunandpal do you know why SQL doesn't allow me to make a remote connection? I've seen every videos from youtube but i couldn't find solution. my pc has windows 11, I've tryng with SQL 16.0 and with SQL 15.0 :( I hope you can help me
thank you very much for the video i am now in my summer training as senior year student in collage and i have this problem , but the difference here is that my laptop PhysicalBytesPerSectorForAtomicity is 4096 but the PhysicalBytesPerSectorForPerformance is 16384 and am scared that this solution will make a problem in my device is it okay to do the steps in this video in this case?
I made the change and I didn't have any problems till now. But I haven't done any analysis on the before and after performance impact. I don't think it will be a problem, go ahead.
It shouldn't have happened ideally, Can you send me the screenshot of this issue on sunandpal@gmail.com, I will check and get back to you if I find something. Cheers!
@@sunandpal After restarting the computer and inserting "sc query MSSQ..." on the command prompt window, next to state, yours is written "4 running" whereas mine is written "1 stopped".How to fix it?
Windows 11 has updated its native NVMe drivers to get the actual sector size directly from the NVMe storage devices themselves but Windows 10 NVMe drivers rely on emulated sector size information from the filesystem drivers, which is not always accurate. Thus, if you are using Windows 10, you don't have to change anything, it should work without any issue. Hope this helps 🙂
Heyy sir I'm facing this error in my asus TUF a15 laptop and i can't find the solution anywhere I tried to download the different version of visual Studio 2022 professional and community version but nothing works k tired to install the external server for the visual Studio but that's not working either so can you help me! Error message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider. SQL Network Interfaces, error: 50- Local Database Runtime error occurred. Erroisoccurred during LocalDB instance startup: SQL Server process failed to start. visual code 2022
Thanks man, solve mine within 1 hour. Thank goodness I found your video
Thank you so much, man! I needed it for school, and I was worried that I wouldn't be able to follow my lesson because I couldn't download SQL Express.
Thanks a lot.....I spent almost 3 hour on resolving but I could not. but after watching your video I resolved it in few minutes.
It's still failing and showing same error.
really thanks bro.. its works , i had been seeing things on internet to solve the issue like 3 hours until see this video...really I'm blissful to your videos...keep it up bro
Thank you so much, I've been trying to install SQL server for the last year and it didn't work until I saw your video, thanks a lot
Brother, I wholeheartedly thank you for this video. I have been stuck on this for 4 days and tried everything, from changing registry files to renaming server names to even resetting my pc TWICE! I have a project to do which required this, so truly appreciate the help. MS should have provided this solution earlier, but ok , nvm, have a good day.
You're welcome brother!
My sql server won’t install kept bringing ‘exit code decimal’
Thank you very much Sunand Pal, you have really helped me a lot. Greetings from Guatemala.
THANK YOU SO MUCH!!!! I had been trying to fix this problem for the last 3 days and I finally fixed it!! God bless
I'm glad I could help!
It's still failing. I've lost the count of how many times I tried to install and uninstall SQL Server.
After struggling 2 days finally found the solution here. Thank you so much brother. You have my subscribe now.👏
Glad I could help
Thank you so much, I've found the solution to the problem I've been looking for for hours. You're excellent.
solved the problem for me, huge thanks
Man really grateful for this video...i have been crawling over all the documentation and yep i read this one too but as a new develpor didn't exactly knew what to do.
this video made my day and really solved the problem
Thank you so much man
I am glad I could help
I just want to say thank you, I really appreciate this video, I was struggling for months for this issue and this finally was the real solution, keep doing videos men, your explanations are great and clear. Regards from Chile !
Thank you very much my friend.
@@sunandpal changeing this 16kb to 4kb wont harm or reduce my pc speeds ?? And how to undo this ?
@@vaibhavkumar5512 I haven't changed back my settings, it has been working fine for me in terms of speed. However, I will research and find out. Cheers!
after searching so many videos, finally this one solved my problem.. thanks
you are a time saver...keep on making these videos.
Brooooooo game tricks brooooo , finally problem solved , thank you so much, lots of love . If this problem would have not fixed , I am about to quit leaning SQL . Once again gametrick brooooo thank you so much!
The solution did really work on my Windows 11. This is the error log:
Feature: Database Engine Services
Status: Failed
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x851A001A
Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
I fixed the problem after 5 days of crying! Thank you.
No worries my friend 🙂
After 3 days of trying every solution I could find, this finally worked for me!
Glad, I could help!
Man! This is fucking great! Please do more tutorial videos like this! This is so much helpful!!!! God bless you
Thank you very much I could finally install the sql server but does it affect the pc in anyway if we change the physical sector bytes? Also is there a way to revert back to the default bytes it used to display? I got no clue if this could cause me trouble in future so I'm looking forward for your response. Thank you
Don't worry there won't be any problem.
Thank you verry much now I can use SQL Sever
Very helpful , you save me. Many thank to you. But i have a little question, after successfully install sql server 2022, do i need to undo what i did in Registry Editor(delete the multi string ForcedPhysicalSectorSizeInBytes)? Thankyou alot.
I haven't tried deleting it, it might probably stop working if we do that
I got it...😊 Thanks for this ... I have searched in many videos to solve this bt I got solution here ur great 👍
Thank u this and reinstalling of the sql server fix my issue
Thank you. Problem fixed.
Thank you, finally I got it!
I have done this and it worked for me after restarting my device
Thanks a lot!
thanquuu so much ,i have been trying to install sql server n having dis issue n finally i found d solution
100 % working done after so much hard work thank you man u trick helped
No worries my friend
Thank you very much, it took me 5 hours to fix the error but luckily I was able to watch your video
Thankyou, this literally saved me 😢.
BRO!!!!!! THANK YOU, YOU'RE A LIFE SAVER!
Thank you for the solution,
I have troubleshooted using registry editor, it helped me a lot
Thanks a lot..!!!
keep the work going on...
No problem bro 🙂
Hi @Sunand Pal,
Thank you for the details.
In my system 'PhysicalbytespersectorforAtomicity is 512'
and when I am adding ForcedPhysicalSectorBytes the issue is still the same.
Can you please help me out here?
Hey did you resolved it
Same My prob
I couldn't find any solution for it
bro you saved my life it's working
Thank you for the details.
In my system 'PhysicalbytespersectorforAtomicity is 512'
C:\Windows\System32>fsutil fsinfo sectorinfo C:
LogicalBytesPerSector : 512
PhysicalBytesPerSectorForAtomicity : 512
PhysicalBytesPerSectorForPerformance : 512
FileSystemEffectivePhysicalBytesPerSectorForAtomicity : 512
Device Alignment : Aligned (0x000)
Partition alignment on device : Aligned (0x000)
No Seek Penalty
Trim Supported
Not DAX capable
Not Thinly-Provisioned
after adding ForcedPhysicalSectorBytes and restart my PC the issue is still the same.
Can you please help me out here?
OMG thank you so much!
Thanks for the solution 👍🏻
I just can say thank you so much!!!
You're very welcome!
@@sunandpal do you know why SQL doesn't allow me to make a remote connection? I've seen every videos from youtube but i couldn't find solution. my pc has windows 11, I've tryng with SQL 16.0 and with SQL 15.0 :( I hope you can help me
@@jesusbe4711 Drop me an email at sunandpal@gmail.com mentioning the details and screenshot, let me see what I can do.
HELLO, WHAT ABOUT DOWNLOADING ERROR WITH JUST "OOPS" AS THE ERROR
Thank youuu soo much brother ❤️ you helped me alot , may God bless you and your family ☺️ Jai shree Ram
thanks bro, it fixed it for me
Thank you so much sir
This was really helpful...Thanks
Hi Sunand, I am getting error ' the system cannot find the path specified'
How to solve this error please.
Hi Payal, Can you send me a screenshot where you are getting this error? I will have a look and get back to you soon.
thank you very much for the video i am now in my summer training as senior year student in collage and i have this problem , but the difference here is that my laptop PhysicalBytesPerSectorForAtomicity is 4096
but the PhysicalBytesPerSectorForPerformance is 16384 and am scared that this solution will make a problem in my device
is it okay to do the steps in this video in this case?
I made the change and I didn't have any problems till now. But I haven't done any analysis on the before and after performance impact. I don't think it will be a problem, go ahead.
Thank you so much. It worked for me🙂
Cheers, mate!
thank you bro. i did it!
THANK YOU MAN, THANK YOU
thanks dude it worked.
You're welcome my friend.
thank you so much bro
I get message 'connection was successful established with server, but then error occured during login process'.... How to solve this
What's the error reason, can you email me the screenshot?
Thankyou so much guyss this worksss
Thank you brother❤
Thank you soo much...
Hi ,when i am trying to execute the command throughing error as access denied what needs to done
That's weird, maybe try running it as administrator
Thank you ❤
You save my life!!!!
everyone says work but it doesnt work for me bro
I have done mentioned steps but still I am getting same error. Please help.
Does SQL server show up in services when you start your system?
i m doing this in windows 10 will it work and if not what is solution because all four are showing 512
@@sunandpal
Thank you so much bro...
Should I add this and then install sql server?
Update: you can make the changes told in the video, restart your computer and install SQL server. It’ll work perfectly!
My device: PhysicalBytesPerSectorForAtomicity 4kb and PhysicalBytesPerSectorForPerformance 16kb. How to fix. Help :
Hey @tantutran3504 , Please go ahead with the fix which I suggested, it should work in your case as well.
why is my drive with sector 2048 but still failing
It shouldn't have happened ideally, Can you send me the screenshot of this issue on sunandpal@gmail.com, I will check and get back to you if I find something. Cheers!
Thaaaaaank you
thank you so much , i fixed successfully😍😍
Cheers!
thanks man
Still it's not working for me 😞
Thanks 🙂
thanks you, is solution for problem thanks
didnt change physical sector byte what i do?
What command did you write?
@@sunandpal its ok now tysm
tks bro
its getting state is 1 stopped what should do for this ?
I didn't get your question
@@sunandpal After restarting the computer and inserting "sc query MSSQ..." on the command prompt window, next to state, yours is written "4 running" whereas mine is written "1 stopped".How to fix it?
thank youuuuuu
Thanks bro it work🥰🥰
💐💐🙏🙏
Still can't solve the problem
What's the exact issue?
Thank u 🤍🥲
why cant i do the same in winows 10
Windows 11 has updated its native NVMe drivers to get the actual sector size directly from the NVMe storage devices themselves but Windows 10 NVMe drivers rely on emulated sector size information from the filesystem drivers, which is not always accurate. Thus, if you are using Windows 10, you don't have to change anything, it should work without any issue. Hope this helps 🙂
@@sunandpal ok thank you so muchh but i updated it win 11 and did the required configuration now its working thankyou
it denied the query
I didn't get your point brother, can you please elaborate?
its doesn't work in pc give me some more tips
Which OS are you using?
Windows 11
@@krushangdave7294 where are you stuck exactly, have you checked the disk sector size?
Heyy sir I'm facing this error in my asus TUF a15 laptop and i can't find the solution anywhere I tried to download the different version of visual Studio 2022 professional and community version but nothing works k tired to install the external server for the visual Studio but that's not working either so can you help me!
Error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider. SQL Network Interfaces, error: 50- Local Database Runtime error occurred. Erroisoccurred during LocalDB instance startup: SQL Server process failed to start. visual code 2022
@@krushangdave7294 you are installing SQL Server or Visual studio? Because this solution is for sql server only.
Indian is number ONE
BRO I KISS YOU BROOOO😘😘😘😘
i got it fixed, thanks
Thank u alot.
Thanks Brother 🙏🏻💞
Thank you so much bro
You're Welcome!
thank you brother ❤❤