NAV2009R2 - Password change via User table is not working?

Slawek_Guzek

Hi All,

It seems that changing Password field on User table does not change users's password on the SQL server. Even if Tools->Security->Synchronize All is executed aftewards the password on the SQL box does not get updated.

There is also no other way around integration - password change function (Tools->Security->Password..) for database users does nothing with Password fied in User table. Password - OnValidate trigger is not even fired..

NAV dababase is configured to use Standard security model.

Is this some new feature in NAV2009 R2 client, or a bug in the first release of NAV 2009 R2 binaries (I am using build no 32012), possibly addressed in some hotfix ?

Thanks for any clues.
Slawek

Slawek_Guzek

Two days and nothing posted ?

Does everybody really knows nothing about this NAV2009 R2 behaviour ?

Slawek

kriki

That fields is only useful if you are using the native DB. If you are using a SQL database, that field is always blank (except if you fill it up manually, but it does not have any function). If you want to change the password, you need to do that directly in SQL Server.
BTW: why are you using database logins and not Windows logins? they are easier to use and also more secure and the user can change it when he wants by changing his Windows-password.
The only reason for having a databaselogin is for people outside of your domain like the people of your NAV-partner in case they open NAV directly on their PC's. (actually it is better doing a remote desktop session on a terminal server and working from there).

Slawek_Guzek

Hi,

Thanks.. We are migrating customer from old Native to 2009 R2 on SQL.. He was using database authentication due to security reasons. He has some password complexity enforcement rules plus some other stuff coded in Password - OnValidate trigger. This is no longer working as the trigger isn't fired when user changes his password.

I was pretty sure that Password field in User table used to be working on SQL in some previous NAV versions.

Slawek