Palo Community Forum

Hello,

I just finished the LDAP (Windows AD) configuration, everything works correctly when I try to login using the login form with excel.
So I tried to use the Windows Authentication, without success for now.
Here is my configuration:
- Jedox 3.3 with Supervision Server
- svs.lic in svs folder
- worker and workerlogin (authentication) configured in palo.ini
- copy of sep.inc.adldap.php and adLDAP.php included in sep.inc.php
- sep.inc.adldap.php and adLDAP.php configured (correctly as I can login with an AD account using the form)

I tried to put a few more logs message in the php files.
When I test the connection with Windows Authentication selected in Excel:
- first log: username is ok (user@domain.com), with a password length = 32 -> authentication return false (cf. line 32 in sep.inc.adldap.php)
- second log: username is ok (user@domain.com), with a password extremly long beginning with `xladdin`; method AuthHelper return true (isExcel=1 on line 38 and user_info returns some information on line 67), but I get the following error message in olap_server.log:
`WARNING: error code: 1019 description: worker authorization failed message: incorrect username or password`
And the following error message in Excel (palo test connection):
`Error connecting to server`

I read some documentation which are talking about:
`When in Excel "Windows Auth." as connection type is used and if "SVSWindowsAuthKey" key (16 char
long string) is present in registry (HKEY_USERS or HKEY_CURRENT_USER depending on type of
installation all/only for me)`
or
`For the use of the Windows authentication, there must be configured accordingly the Jedox database
connection in the Jedox database manager.`

But I cannot find what exactly these refers to... Do I have to create a key in the client registry? What exactly means the second sentence (Jedox database connection)?

Any help would be more thant appreciated

thanks!

Laurent