DotNetNuke - SQL Server Statements to Change User Password



--Get PasswordSalt & Password Format
SELECT * from aspnet_Membership

--Get User ID
SELECT * FROM Users

--Get Portal ID
SELECT * FROM PortalAlias

--Get Application Name
SELECT * FROM aspnet_Applications

--Change Password, RUN aspnet_Membership_SetPassword Stored Procedure
EXEC aspnet_Membership_SetPassword 'applicationname', 'username', 'newpassword', 'passwordsalt', 'passwordformat'

--Confirm
SELECT * from aspnet_Membership



 

What did you think of this article?




Trackbacks
  • No trackbacks exist for this post.
Comments
  • No comments exist for this post.
Leave a comment

Submitted comments are subject to moderation before being displayed.

 Name (required)

 Email (will not be published) (required)

Your comment is 0 characters limited to 3000 characters.