Cannot change user from Windows Authentication to Forms Authentication

[Robert]

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?

[Joel]

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

[TMatt]

I´ am interessted too in that script.



Thanks

[Joel]

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


Kind regards,
Joel
the Telerik team

[TMatt]

Thanks

script arrived me.

[Scott Christian]

Could I get the script as well?

Thanks

Scott

[Joel]

Hi Scott,

I have sent the script to you as well.

Regards,
Joel
the Telerik team

[Frederick]

Can I get a copy of the script as well? Thank you.

[John]

I am in need of this script as well.

[Kamen Ivanov]

Hi John,

I have replied you in the support ticket thread.

All the best,
Kamen Ivanov
the Telerik team

[Boot]

Please send me that script as well.

Thanks,

[Kamen Ivanov]

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

[Jesper]

...and if you wan't to convert from form to windows user?

[Angel]

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 = '[e-mail]' -- 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 = '[e-mail]', -- set different email of the user

    LoweredEmail = '[e-mail]',

    PasswordQuestion = 'SomethingDifferentFromCurrentUsername'

WHERE LoweredEmail = '[e-mail]' -- 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

[Philip]

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

[Angel]

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