Geeks With Blogs
Jenson Code Ranch Code Ranch for Web and Mobile Development
Repeat this 10 times, DO NOT FRET. 

Trust me, at first I really freak the hell out of me for unable to do anything, even though what I need to do is just to access my local database as per normal, like what any developer would do every now and then. 

I've been googling quite a fair bit, by stating fair bit is just not to scare you out. 

Maybe the Lady Luck is just not with me, I did quite a number of googling until I stumbled upon the right terms that nail the closest results I could ever get! 

This is the link you need to follow if you know what you are going to do, and if you have Local Administrator access. Otherwise, please look for any friendly system guy to bail you out from the endless locked out and frustration you've been enduring thus far. 

The trick is to get your MS SQL instance to restart into Single User Mode, and then Add your unlocked Windows Account to the desired roles, as well as allowing you to reset your sa account password. 

Here you go: 

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?view=sql-server-2017 

or click HERE

I hope it really help the poor souls like me out there. 

Posted on Monday, August 13, 2018 3:57 PM MS SQL , Account Lock-out , SA lock-out , Windows Account Lock-out , Microsoft , Single-User Mode | Back to top


Comments on this post: How to Reset Your MS SQL Password if You've Forgotten your SA password, and your Windows Account is locked out

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Jenson | Powered by: GeeksWithBlogs.net