Mistakenly entered the wrong SuperUser account username and email address when installing DotNetNuke and immediately forgot what I entered.

Went into Sql Managment Studio to find out what it was and surprisingly I found the username and email address in two different tables. They are the Asp Membership table and a DotNetNuke User table. Hmm, that seems like a violation of the first rule of database design, do not duplicate the same information in different tables.

Note that I prefix all my DotNetNuke tables with "dnn_".

If you want to change the username and email address, here is where they are:

1. dbo.aspnet_Users
2. dbo.dnn_Users

I can understand wanting to have your own userid key column that is an integer and not a guid like in the asp dot net membership provider. I have done the same thing.

Why duplicate the other information though.

Well it is there twice and you are going to have to deal with it if you write code or go into the tables directly.

By Andrew Weitzen, Bronze Inc.(c) 2010

Bronze is the publisher of several online Internet journals including: InternetHandholding.com, DomainNames.gs, DotNetNuke.bz, Programmer.bz, Software.vg, WebHosting.vg