I found this issue too but this is entirely different level issue and totally my careless mistake

I changed the IP of the machine. Then tried to connect using ssms.

Turns out, i forgot to change the IP too in TCP/IP protocols in SQL Server Network Config, but the locked out login error was really misleading for my case.

Just in case anyone did the same and didnt check. I almost created new admin acc just for that.