Blog Detail

Hi Guys,

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-

1. Database Name - This is the name of your commerce database.
2. Application Name - This is the name of application that is stored in the commerce database.

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