User Friendly Interface for unlocked users on the eService Portal

Feb 3, 2010 at 1:56 PM
Edited Feb 3, 2010 at 1:57 PM

We have been using the eService Portal and are very happy with its results.  However, one issue we have ran across is that when a portal user locks themselves out, due to typing in their passwords incorrectly multiple times, we have to run the SQL script below on the aspnetdb SQL database to unlock them.

Does anyone know of an already developed GUI that can be used to unlock a user, so that we do not need to perform this task in SQL?  Right now only two people in the US use this and we really need to be able to distribute it to our European team as well as a user could lock themselves out at 9 am CET and it could take six hours for us to provide assistance on this and we really do not want more people using the code below.

We can develop the GUI to do the task below, but I do not want to duplicate the effort if another tool is already available.

Any assistance is extremely appreciated.

Jack


USE aspnetdb

 

-- 1) Find the user from their email address 

DECLARE @email as NVARCHAR(256)

 

set @email = 'michellew@hotmail.com' 

select * from dbo.aspnet_Membership where email = @email

 

 -- 2) Using the UserID, we need to find the username from the table below - set @User to the UserID that you recieved from the query above

 DECLARE @user as UNIQUEIDENTIFIER

 set @user = '0168FCB2-B6DC-4B03-9C4D-92CC6EEA5544'

 select * from dbo.aspnet_Membership where Userid = @user

 

-- 3) Only use if needed for further analysis

--select * from dbo.aspnet_Users where Userid = @user

 

 -- 4) Unlock a user who is locked out  Remove the two dashes below and highlight from #2 to the line below

--update dbo.aspnet_Membership set IsLockedOut = 0 where Userid = @user

Feb 3, 2010 at 9:25 PM
Edited Feb 3, 2010 at 9:26 PM

Hi Jack,

I not heard about tool specific to manage eService DB but there are several tools to manage users in asp.net membership databases like one buildin in Visual Studio.

 

Check this article: http://weblogs.asp.net/scottgu/archive/2006/07/18/Remote-Membership_2F00_Roles-Management-of-ASP.NET-2.0-Applications.aspx

 

Using these GUI's you can easly unlock your user,delete but there is a problem with create a user because it must to be associeted with MS GUID.

Let me know if you will have any question.

 


My Dynamics CRM Blog: http://bovoweb.blogspot.com

 

 

Feb 19, 2010 at 12:09 AM

try this: http://aspnet.4guysfromrolla.com/articles/052307-1.aspx

I use this as a base for admin pages for almost every project I do - provided of course that the membership provider is sql :)

HTH
Rgds - Marcus.