DAC Client – Datawarehouse Administration Console Can’t Authenticate User

Recently came across an issue while connecting to DAC client, user can’t authenticate and unable to open console.

To resolve the issue followed the steps as described in MOS note: 1346696.1

1) clean up W_ETL_USER by deleting the user from the table.

DELETE FROM W_ETL_USER

2) Login to DAC Client with your tableowner username and password to DAC Repository database.

DAC will create default Administrator account with the same password for you
(In our case it was dacrep database user)
3) Close and Restart DAC Client again

4). You will be prompted for a new Administrator username and password.
You can enter Administrator/Administrator here

5). Login

6). Log out and then login in with Administrator/Administrator user.
This should now work