OMG! Thank you so much! I could not figure out for the life of me what was going on, but your video was easy to follow and now my server is working. Thank you!
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.
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!
I just add step here. After getting this error. 1 uninstall it from control panel. 2 restart the system. 3. Add the key from CMD or any others two way as administration access. 4. Restart the system. 5. For installation start from download the setup from microsoft and run the setup as admin. It will fix.
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
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.
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!
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.
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?
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 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
@@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
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?
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.
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
OMG! Thank you so much! I could not figure out for the life of me what was going on, but your video was easy to follow and now my server is working. Thank you!
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.
You are the best! Thank you so much, now I'm able to work on my project. My best wishes to you!
My sql server won’t install kept bringing ‘exit code decimal’
same problem dude, did you already find the solution? thanks
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.
Thankyou so much brother bhot time se try kar raha tha per nahi ho raha tha per ab ho gaya thanks to you
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 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!
After 3 days of trying every solution I could find, this finally worked for me!
Glad, I could help!
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!
After struggling 2 days finally found the solution here. Thank you so much brother. You have my subscribe now.👏
Glad I could help
Thanks a lot man!!
May god really bless you always!
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!
Thank you very much Sunand Pal, you have really helped me a lot. Greetings from Guatemala.
after searching so many videos, finally this one solved my problem.. thanks
Thank you. Problem fixed.
It's still failing and showing same error.
did you solve this problem or facing it ?
I just resolved it, with the help of this video.
I just add step here.
After getting this error.
1 uninstall it from control panel.
2 restart the system.
3. Add the key from CMD or any others two way as administration access.
4. Restart the system.
5. For installation start from download the setup from microsoft and run the setup as admin.
It will fix.
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 got it...😊 Thanks for this ... I have searched in many videos to solve this bt I got solution here ur great 👍
Man! This is fucking great! Please do more tutorial videos like this! This is so much helpful!!!! God bless you
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 🙂
solved the problem for me, huge thanks
you are a time saver...keep on making these videos.
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!
100 % working done after so much hard work thank you man u trick helped
No worries my friend
Thank you so much, I've found the solution to the problem I've been looking for for hours. You're excellent.
thanquuu so much ,i have been trying to install sql server n having dis issue n finally i found d solution
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 🙂
Thank u this and reinstalling of the sql server fix my issue
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 😢.
It's still failing. I've lost the count of how many times I tried to install and uninstall SQL Server.
i'm also facing the same issues did you solve it ?
@@tapabratapal3276 Sorry, I solved it but I didn't remember how. 🙏
@@tapabratapal3276 Me too
I am facing same problem issue
I have done this and it worked for me after restarting my device
Thanks a lot!
Thank you verry much now I can use SQL Sever
Thank you so much. It worked for me🙂
Cheers, mate!
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
HELLO, WHAT ABOUT DOWNLOADING ERROR WITH JUST "OOPS" AS THE ERROR
how to edit Modify New Data Value bro
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?
Thank youuu soo much brother ❤️ you helped me alot , may God bless you and your family ☺️ Jai shree Ram
thank you so much , i fixed successfully😍😍
Cheers!
BRO!!!!!! THANK YOU, YOU'RE A LIFE SAVER!
Thank you, finally I got it!
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?
Thank you very much its working for me now. .....................
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
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
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 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.
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.
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!
Still it's not working for me 😞
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
Thanks for the solution 👍🏻
didnt change physical sector byte what i do?
What command did you write?
@@sunandpal its ok now tysm
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?
everyone says work but it doesnt work for me bro
thanks bro, it fixed it for me
Thankyou so much guyss this worksss
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!
This was really helpful...Thanks
thank you bro. i did it!
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.
thanks dude it worked.
You're welcome my friend.
OMG thank you so much!
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
Thank you so much sir
You save my life!!!!
THANK YOU MAN, THANK YOU
Still can't solve the problem
What's the exact issue?
Thanks bro it work🥰🥰
Thank you soo much...
it denied the query
I didn't get your point brother, can you please elaborate?
Thank you so much bro
You're Welcome!
thanks you, is solution for problem thanks
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.
Thank u alot.
i love you 😘
@@auraofher9 I love you more 😘
i got it fixed, thanks
Very nice bro
Thanks 🙂
Indian is number ONE
thanks man
Thaaaaaank you
BRO I KISS YOU BROOOO😘😘😘😘
thank youuuuuu
tks bro
Thank u 🤍🥲
💐💐🙏🙏
can you help me? when ı write this to the command prompt it writes "access is denied"
Thank you brother❤
thank you brother ❤❤
Thank you ❤
Thanks Brother 🙏🏻💞
Thank you brother
thank you so much bro