Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Provider and Extension ForumsProvider and Extension ForumsAuthenticationAuthenticationChanging the Membership database to an extrenal aspnetDB so that is can be shared by other .net appsChanging the Membership database to an extrenal aspnetDB so that is can be shared by other .net apps
Previous
 
Next
New Post
6/11/2012 10:40 AM
 

Hello everybody,

I am new to DNN and just started playing around with v6.2.  My problem is as follows:

I have a company wide asp.net application (on entity framework) running on our web server using sql 2008 database with the aspnetDB for the classical membership schema.  This application has already all my users and now that I am creating a specific portal for that application I would like to use the same DB on DNN so that my users will not have to register again.

My original thought was to disable registration from the portal as I do have a registration process already built in my aspnet application.  So I only need the users to be able to login in the portal.  Is there a build in process (via admin or host) to change the membership database?

Thanks in advance for your time
 
New Post
6/13/2012 11:45 AM
 
there is a "InstallMemberRole" setting in the web.config that is supposed to allow a site to install into the same database as an existing MS memberrole database and that would seem to fit your needs - however I caution you to test that in a test enviroment as it was added around 2005 and I dont think its been used by very many users (I never have and dont know of anyone who has). You can of course write your own authentication provider to authenticate against an alternative source - which could be an external database (as yours in aspnetDB you'd need to use the same machinekey values to ensure that passwords can be correctly decrypted)

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
6/14/2012 6:01 AM
 

Thanks for your answer I did not try it cause i found a way of working out my problem.

I had an application already running with the users ready in aspnet_membership db called (AspnetDB). I needed dnn to work on its own db but read the users from the AspnetDB that was already working. Ofc I would have to create the users in the dnn user tabels too.

SoI changed the config of dnn to work with a new connection string for membership purposes only, and I manualy inserted a user in dnn user tables to match the old aspnet_membershipDB.  Checking that machine keys and application names / keys where the same it did not work case DNN uses a vw_users to read and check users while logging. That view had an inner join with:

dbo.aspnet_Membership
dbo.aspnet_Users

so I changed that to my

AspnetDB.dbo.aspnet_Membership
AspnetDB.dbo.aspnet_Users

then copied all users to DNN user tables , roles etc and it works like a charm :)

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Provider and Extension ForumsProvider and Extension ForumsAuthenticationAuthenticationChanging the Membership database to an extrenal aspnetDB so that is can be shared by other .net appsChanging the Membership database to an extrenal aspnetDB so that is can be shared by other .net apps


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out