We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
SOLVED

Lost Alteryx Connect Admin User

erich_shiino
7 - Meteor

HI, I lost the Alteryx Connect admin user and password and it is not based on the AD Users and Groups is there any way to create another admin ? 

 

Best Regards, 

Erich

3 REPLIES 3
James_First_Mile
8 - Asteroid

Hi Eric,

 

I think I already know the answers but, short of doing a reinstall...

 

  1. do you have a named admin who can login and access the Administration Console? From there, you'd go to Password Settings and change the Admin Password. If that is not an option...
  2. Is there a chance that the H2 Password is the same as the Admin Password? If so, you can find the H2 password by doing the following:
    • RDP into the Connect server
    • Locate the 'alteryx_connect.properties' file (typically in [installation path]\ac_work
    • open with Notepad and you'll see the db password

Train_Connect.jpg

 

erich_shiino
7 - Meteor

I did a reinstall in the mean time.. 

So I did not get to try the H2 password, but it is great to know! 

 

Thank you!

PetrH
Alteryx
Alteryx

Hi in case that password for admin is not the same with database password, there is still chance to reset admin password to default.

But im must be done in database (so the database console needs to be enabled) This can be done by truncating table STD_XFORMS.SUPERADMIN. (delete all records) than the default password would be again Conn3ct!