SQL Help - Unlock admin account

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
5/17/2009 3:51:31 AM
Gravatar
Total Posts 7

SQL Help - Unlock admin account

I apologize for being a N00b.  I somehow managed to lock my admin account out.  From searching this site I understand that I need to go into SQL Server Managment Studio and change the table mp_users IsLockedOut to 0.  The problem is, I dont know how to actually execute that change.

This is SQL Express 2008, I am connected to my SQL server using the SA password. 

In SQL Managment Studio I expanded Databases \ DataBase Name \ Tables \ dbo.mp_Users \ Columns and I see "IsLockedOut"

I double Click on it  - But I dont know what to do now.

Any help would be great ....

Thanks

5/17/2009 10:06:28 AM
Gravatar
Total Posts 18439

Re: SQL Help - Unlock admin account

You should right click the table and choose "Edit  Top 200 Rows"

Hope it helps,

Joe

5/17/2009 12:16:59 PM
Gravatar
Total Posts 7

Re: SQL Help - Unlock admin account

AWESOME - edited the top 200 rows, changed the value from true to false - worked liek a charm.  Thanks Joe

You must sign in to post in the forums. This thread is closed to new posts.