User credential check in a NAV three tier environment

DHendriksen · 2011-06-27

Hi all,
As you all probably know you can validate an user password by the following code:

IF recUser.GET(codUser) THEN BEGIN
recUser2."User ID" := recUser."User ID";
recUser2.VALIDATE(Password,txtPassword);
IF recUser2.Password <> recUser.Password THEN
ERROR('Password is incorrect')
ELSE
ERROR('User validated');
END;

But this procedure doesn’t work when you pass the user and password using the Dynamics NAV Web service. The result is that the password from the recUser is something like ~%$@&%!$#, and after validating the txtPassword it still shows me the password. So the encryption does not work.

Does anyone have any idea what's this all about, and is there a solution? Is it the three tier environment why the encryption does not work?

Thanks in advance.

Greetings,
Don

kine · 2011-06-27

Because the Webservices are working only with windows authentication, isn't it better to use the standard windows authentication? Do you really ask user for password and validate it yourself?

DHendriksen · 2011-06-28

Because the (client) software runs on a terminal which is used by several employees we have chosen to not use Windows logon.

I guess that the finsql.exe can encrypt a password, and the Dynamics NAV server (where all request are processed from the Web service) can not encrypt a password. The reason for this thought is the only possibility to use Windows logon. Does anyone agree this?

Regards,
Don

kine · 2011-06-28

Yes, I think same...

pdj · 2011-07-02

This method only works for on the Native DB and only for Database Logins.
To validate a SQL userid/pwd you could try to make an ADO connection using the specified credentials.

Howdy, Stranger!

Quick Links

Categories

User credential check in a NAV three tier environment

Comments