Windows Authentication error after upgrade from 2019.3 to 2020.1 version
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I need urgent support in fixing authentication error in alteryx gallery. I upgraded alteryx server from 2019.3 to 2020.1. After upgrade, when I try to log in to gallery, I received following error. I selected windows integrated authentication in configuration. Can someone please help us to fix this error?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
2020.2 Major released , is this issue fixed in latest version?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I upgraded over the weekend, and also experienced this problem. We were able to resolve. The problem is the WindowsIdentity collection on a user's profile is somehow getting removed on initial login after the upgrade. We found that restoring the WindowsIdentity collection values directly in the MongoDb corrects the issue. Here are the steps:
- Open a command prompt on a server that can connect to your Mongo Db
- Execute command: cd C:\Program Files\Alteryx\bin
- Execute command: mongo <Mongo Db server name>:<Mongo Db port number>/AlteryxGallery -u <username> -p <password>
- Execute command: db.users.find({"Email":"<email address of affected user>"}).pretty() - Use this result to confirm the WindowsIdentity collection is NULL
- Execute command: db.users.update({"Email":"<email address of affected user>"}, {$set: {"WindowsIdentity.Sid":"<Sid of affected user>"}})
- Execute command: db.users.update({"Email":"<email address of affected user>"}, {$set: {"WindowsIdentity.DisplayName":"<display name of affected user>"}})
- Execute command: db.users.update({"Email":"<email address of affected user>"}, {$set: {"WindowsIdentity.Name":"<name of affected user; this comes from windowsIdentitys.Name field>"}})
- Execute command: db.users.update({"Email":"<email address of affected user>"}, {$set: {"WindowsIdentity.SamAccountName":"<SamAccountName of affected user>"}})
- Execute command: db.users.find({"Email":"<email address of affected user>"}).pretty() - Use this to confirm the WindowsIdentity collection is populated.
I would recommend contacting Alteryx Support to confirm where to get these values.
- « Previous
- Next »