Link to home
Start Free TrialLog in
Avatar of vmandem
vmandem

asked on

Add users to the ASPNET_Membership table in MSSQL 2005

Hi, I want to add users to the ASPNET_Membership table in the aspnetdb database in MSSQL 2005. Can anyone tell me how to add users.
Avatar of Craig Wagner
Craig Wagner
Flag of United States of America image

There are some inter-relationships between the various tables in the membership services schema, and the passwords are encrypted, so my suggestion would be to use Membership.CreateUser() to ensure all the data gets persisted properly.

http://msdn.microsoft.com/en-us/library/system.web.security.membership.createuser.aspx
Avatar of urir10
urir10

Membership.CreateUser
Avatar of vmandem

ASKER

I have a suituation where I have 500 users that I want to create in the membership schema, how do I do that. Basically I want to authenticate the users in Sharepoint using aspnetdb database. Please let me know as soon as possible.

I looked at the msdn link and when it says Membership.CreatUser does it automatically saves to the aspnetdb database or is something I should use sql connection to point to the aspnetdb database. I atleast want to try with one user and if it works than I have to import all the 500 users.
ASKER CERTIFIED SOLUTION
Avatar of Craig Wagner
Craig Wagner
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial