Today I am going to tell you a quick way to unlock the Episerver commerce user account using a small SQL query.
This is useful when your account is locked through multiple invalid password attempts.
So for this, you need to find two values-
Please refer my previous blog post to see how you can retrieve these values Link
If you followed my previous post then now you are almost done with requirement gathering.
So now again go back to the SQL Server Management Studio and select the commerce database.
Right-click on the database and click"New Query". The query editor will open so copy and paste the below query in this editor and update the highlighted values that gathered in the above steps.
SQL query for unlocking the user account
USE [EcfSqlConnection_0fc2aba3] GO DECLARE @return_value int EXEC @return_value = [dbo].[aspnet_Membership_UnlockUser] @ApplicationName = N'ECApplication', @UserName = N'admin' SELECT 'Return Value' = @return_value GO
Try to login again with your credentials
Thanks for reading this blog post I hope it helps
Thanks and regards
Ravindra S. Rathore