LockedPlugging in standard SqlMembershipProvider

Author
Post
Essentials Only Full Version
beelineuk
Version 3 user
  • Total Posts : 16
  • Reward points : 1620
  • Joined:
  • Status: offline
(permalink)
0

Plugging in standard SqlMembershipProvider

Hi,
 
I've trying to evaluate your software and running into a few issues getting the SqlMembershipProvider to work with an external database. I've added the providers for the external membership database to the web.config and changed the EnableMembershipIntegration setting to true.
 
When I try to login with a user I know exists in my external membership database I get an error saying "There is no such user in our database". If I run SqlProfiler I can see it's requesting the relevant user details from my external database, so what am I missing? 
 
Thanks,
 
Mike
 
 
 
 
#1
E-mail

4 Replies Related Threads
    beelineuk
    Version 3 user
    • Total Posts : 16
    • Reward points : 1620
    • Joined:
    • Status: offline
    Re:Plugging in standard SqlMembershipProvider (permalink)
    0
    I created a new user and that seemed to work (created the user in membership database and forum database). I then deleted the user in the pgd_Members table and tried logging in again. This time the user was successfully recreated in the forum table and the system logged in successfully.
     
    For some reason I still can't login using other users, and it seems to be related to the fact that all my other users have usernames of the format "domain\username". I'm not why why this effects the ability to login or migrate the users.
    #2
    beelineuk
    Version 3 user
    • Total Posts : 16
    • Reward points : 1620
    • Joined:
    • Status: offline
    Re:Plugging in standard SqlMembershipProvider (permalink)
    0
    Excuse the conversation with myself, feel free to jump in and help me out here.
     
    I've managed to work out that the the issue was actually related to the fact that the forum does not allow duplicate email addresses. The user I was trying to import from my external membership tables shared the same email address as my admin user. Pulling in a user with a different user works ok.
     
    #3
    APGvNext (Sam)
    vNext Dev
    • Total Posts : 12456
    • Reward points : 218330
    • Joined:
    • Status: offline
    Re:Plugging in standard SqlMembershipProvider (permalink)
    0
    Hi,
     
    The forum software requires unique email address for each account, so whenever it encounters duplicate address (already in forumdb), it won't import again.
     
    Is it just a test account or do you allow duplicate emails in your SQL membership provider?

    vNext: Overview | Content Publishing | Community Features | Online Demo
    Latest: 4.3
    View current software pricing.
    #4
    Guest
    Super Member
    • Total Posts : 958
    • Reward points : 0
    • Joined:
    • Status: online
    Re:Plugging in standard SqlMembershipProvider (permalink)
    0
    Thanks for your help. I'm integrating with Sitecore membership providers. These do allow duplicate emails, for instance all of the Sitecore admin accounts currently use my email address, as does the default forum admin account I set up during installation.
     
    I'm hoping we can manage this going forward, but it would be good if the forum had the option to allow dup emails and restrict only on username.
    #5
    Jump to:
    © 2013 APG vNext Commercial Version 4.3