Cannot change user from Windows Authentication to Forms Authentication

16 posts, 0 answers
  1. Robert
    Robert avatar
    5 posts
    Member since:
    Sep 2010

    Posted 14 Dec 2011 Link to this post

    With the release of TeamPulse 2011 R3 with the new ability to do Forms Authentication, we need to be able to change some users that were originally set up for Windows Authetication over to Forms Authentication and there seems to be no option to do that.  The only option appears to be to create a new user set to Forms Authentication but that breaks everything that is already assigned and credited to the now-old Windows Authentication user of the "same name"  Surelym there is a way to do this?
  2. Joel
    Admin
    Joel avatar
    300 posts

    Posted 14 Dec 2011 Link to this post

    Hi Robert,

    Unfortunately there is no built in way to convert a windows authentication user to be a forms authentication user.  I agree that this would be very useful and I've added this as a feature to our backlog and given you some Telerik points.

    From a database perspective it's not very difficult to convert a user to a forms user and I will email you a script to help you with that.

    Thanks,
    Joel
    the Telerik team
    New TeamPulse release is here!
    Want to know what’s New and how TeamPulse could help you better tight with your clients?
    Reserve a seat for the TeamPulse R3 Webinar today!
  3. TMatt
    TMatt avatar
    46 posts
    Member since:
    Feb 2011

    Posted 15 Dec 2011 Link to this post

    I´ am interessted too in that script.



    Thanks
  4. Joel
    Admin
    Joel avatar
    300 posts

    Posted 16 Dec 2011 Link to this post

    I will send the script to the email address associated with your account.


    Kind regards,
    Joel
    the Telerik team
    New TeamPulse release is here!
    Want to know what’s New and how TeamPulse could help you better tight with your clients?
    Reserve a seat for the TeamPulse R3 Webinar today!
  5. TMatt
    TMatt avatar
    46 posts
    Member since:
    Feb 2011

    Posted 17 Dec 2011 Link to this post

    Thanks

    script arrived me.
  6. Scott Christian
    Scott  Christian avatar
    6 posts
    Member since:
    May 2009

    Posted 11 Apr 2012 Link to this post

    Could I get the script as well?

    Thanks

    Scott
  7. Joel
    Admin
    Joel avatar
    300 posts

    Posted 13 Apr 2012 Link to this post

    Hi Scott,

    I have sent the script to you as well.

    Regards,
    Joel
    the Telerik team
  8. Frederick
    Frederick avatar
    1 posts
    Member since:
    Oct 2011

    Posted 30 May 2012 Link to this post

    Can I get a copy of the script as well? Thank you.
  9. John
    John avatar
    19 posts
    Member since:
    Dec 2011

    Posted 12 Jul 2012 Link to this post

    I am in need of this script as well.
  10. Kamen Ivanov
    Admin
    Kamen Ivanov avatar
    79 posts

    Posted 13 Jul 2012 Link to this post

    Hi John,

    I have replied you in the support ticket thread.

    All the best,
    Kamen Ivanov
    the Telerik team
  11. Boot
    Boot avatar
    4 posts
    Member since:
    Feb 2009

    Posted 23 Jan 2013 Link to this post

    Please send me that script as well.

    Thanks,
  12. Kamen Ivanov
    Admin
    Kamen Ivanov avatar
    79 posts

    Posted 24 Jan 2013 Link to this post

    Hi Nicholas,

    Here is a link to our documentation explaining how to convert user from windows to forms.
    I recommend you to create a back up of your database before you start the conversion just in case something goes wrong.

    I hope that everything will go smoothly.

    Greetings,
    Kamen Ivanov
    the Telerik team
  13. Jesper
    Jesper avatar
    21 posts
    Member since:
    Oct 2012

    Posted 13 Mar 2013 Link to this post

    ...and if you wan't to convert from form to windows user?
  14. Angel
    Admin
    Angel avatar
    15 posts

    Posted 14 Mar 2013 Link to this post

    Hello Toke,

    There is no way to convert users authentication in TeamPulse. As a workaround you can do this by modifying the existing user and afterwards setting up a new one with the same username and e-mail but different authentication. The following script will help you to modify your existing user:
    Copy Code
    USE [TeamPulse]
    -- Modify user in User table
    UPDATE [User]
    SET Username = 'someDifferentUsername'-- set different username of the user
        Email = 'wrong@Email.com' -- set different email of the user
    WHERE UserID = @UserID -- The Id of the current user
    GO
    -- Modify user in aspnet_Membership table
    UPDATE [aspnet_Membership]
    SET Email = 'wrong@Email.com'-- set different email of the user
        LoweredEmail = 'wrong@email.com',
        PasswordQuestion = 'SomethingDifferentFromCurrentUsername'
    WHERE LoweredEmail = 'current@email.com' -- email of the current user
    GO
    -- Modify user in aspnet_Users table --
    UPDATE [aspnet_Users]
    SET UserName = 'ModifiedUsername'-- set different username of the user
        LoweredUserName = 'modifiedusername'
    WHERE LoweredUserName = 'username' -- username and the domain of the user
    GO


    After you modify the user you can delete it and you just have to set up a new one with the desire authentication type.

    If you have further questions or issues please don't hesitate to contact us. Regards,
    Angel
    the Telerik team
  15. Philip
    Philip avatar
    1 posts
    Member since:
    Feb 2013

    Posted 22 Jul 2013 Link to this post

    Angel,

    I hate to jump on an old thread but I cannot find any other mention of this while searching Telerik's site.

    Can you please confirm that the script you provided above and the one linked from Kamen Ivanov HERE, are applicable to and valid for use with TeamPulse v.2013.1.606.0??

    Thank you,
    Phil




  16. Angel
    Admin
    Angel avatar
    15 posts

    Posted 23 Jul 2013 Link to this post

    Hello Philip,

     The scripts for changing users authentication in TeamPulse are updated. Please take a look at these KB articles in order to Convert Windows user to Forms user or Convert Forms user to Windows user.
     There is a feature request in our Ideas & Feedback Portal about this issue, so you can give a vote up to help us move it faster in development.

     If you have further questions or queries, please don't hesitate to contact us.

    Regards,
    Angel
    Telerik
Back to Top