How to set the Password from SQL using aspnet_Membership_CreateUser

R

Roberto Kohler

We need to automate user creation by importing data from another system.
We would like to create the users with the aspnet_Membership_CreateUser
stored procedure, but we haven't figured out how to set the password.

exec ASPNETDB.dbo.aspnet_Membership_CreateUser
@ApplicationName,
@UserName,
@Password,
@PasswordSalt,
@Email,
@PasswordQuestion,
@PasswordAnswer,
@IsApproved,
@CurrentTimeUtc,
@CreateDate,
@UniqueEmail,
@PasswordFormat,
@UserId OUTPUT

How do we create a hashed Password ?
How do we create/select a PasswordSalt ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,576
Members
45,054
Latest member
LucyCarper

Latest Threads

Top