HomeHomeDotNetNuke Forg...DotNetNuke Forg...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)
 
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
HomeHomeDotNetNuke Forg...DotNetNuke Forg...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


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

Attend A Webinar
Start  Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.