Hello...

I have a large SQL Database system that we want to use DNN as a front-end tool to gain access to the data.  I would like to programmatically create users in the DNN system as users are added to our database system using SQL that populates table/rows of aspnet security tables and using the DNN stored procedures.

So far my SQL Stored procedure creates the following entries in the Users, UserRoles, and UserProfile tables.

Then I execute the aspnet_Users_CreateUser, aspnet_Membership_CreateUser stored procedures to create the membership records to the DNN application with a default password of 'password123'.  On the Users table I have set the UpdatePassword column set to a '1' so that the user when the enter into the DNN system the 1st time they are required to enter a new password.

The user is able to log into the DNN site with their username and default password without issues.  My problem is that when they have made it to the 'change' password web page and then click the 'change password' link to change their password an error is thrown saying that 'A critical error has occured. Value cannot be null. Parameter name: username'

I am assuming that I have an incomplete record that is missing in the value for username...but I am unable to locate it.

What is the proper method of creating user accounts in DNN or am I missing a step here.

Thank you for your assistance.

...cordell...

Hi,

you can use builtin funciton CREATEUser from usercontroller class, which is residing in Dotnetnuke libarary.

I had same problem, my users are from other SQL Database, i just wrote 5 lines function which transfer the users to my DNN database.

Using this you dont have to worry about the stored procedures and database structures etc.

GOOD LUCK

Aamir