Problem in Window AUthentication

jaiverma2k2

We have a NAV5.0 (window authentication) running with SQL server 2005.
We are facing probelm in some transactions e.g. Posting of PO, modify in item card. Error message appear "Combination of USer ID and paswword is incorrect".
If i give a sysadmin role (sqlserver role) to that user then all the transaction is working fine OR if i take a complete backup from NAV and Delete/Recreate the DB and restore the backup then also it's working fine (without giving sysadmin role).

i want to know the proper solution and root of this issue.

:?: :?:

garak

Did you synch. the permission (tools/security/synchronize) while the users are logged on?

kine

Are you using extended security model or standard one? (Database-alter-last tab)

stryk

This looks like some NAV processes are trying to establish another connection to the SQL Server... ?! Are you using MS ADO or anything? Any Linked Objects? Anything that triggers a logon to the SQL Server?

jaiverma2k2

User is already sysnc.
we are using extended security model.

There is nothing which triggers a SQL logon process.
:?:

stryk

Hmmm ... strange. Would it be possible to switch to "Standard" security (highly recommended!)? Does the error still occur then?