Inscrit le: 28 Sep 2017
|Posté le: Ven 17 Nov - 13:23 (2017) Sujet du message: sql server account locked out error!
I have an asp.net application that connects to a database. I've set up the connection string with the correct server name and username/password. This use to work perfectly. Suddenly for some reason, when i navigate to the site i get a Login failed for user admin. Account locked. I check the server and the account is not locked, but just to be sure i reset the password and change my conn string accordingly. This makes no difference and i still get the account locked error message. Interestingly it works for the sa user but not for my admin user, i could understand if there was some permission error with the admin user, but i dont get why it keeps saying the accounts locked?
Any ideas as to why this occurs and how i can fix it?
I didn't find the right solution from the Internet.
References https://forums.asp.net/t/1519008.aspx?sql server account locked out error