Problem in Window AUthentication

jaiverma2k2
jaiverma2k2 Member Posts: 112
edited 2009-07-01 in SQL General
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.

:?: :?:
Regards,
Jai Verma

Comments

  • garak
    garak Member Posts: 3,263
    Did you synch. the permission (tools/security/synchronize) while the users are logged on?
    Do you make it right, it works too!
  • kine
    kine Member Posts: 12,562
    Are you using extended security model or standard one? (Database-alter-last tab)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • stryk
    stryk Member Posts: 645
    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?
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • jaiverma2k2
    jaiverma2k2 Member Posts: 112
    User is already sysnc.
    we are using extended security model.

    There is nothing which triggers a SQL logon process.
    :?:
    Regards,
    Jai Verma
  • stryk
    stryk Member Posts: 645
    Hmmm ... strange. Would it be possible to switch to "Standard" security (highly recommended!)? Does the error still occur then?
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool

Categories