Synchronization of logins between Nav 2009 and Sql server

usha2009
usha2009 Member Posts: 11
edited 2011-05-30 in SQL General
Hi

Could you please give the step by step procedure or links explaining the synchronization of logins between Nav 2009 and Sql server.

Thanks and regards,
Usha.

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Tools, Security, Synchronize all logins
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • usha2009
    usha2009 Member Posts: 11
    hI Daniel,

    Thanks for your reply. Could you please enlighten me on what should be the security and roles at Nav 2009 and sql server 2008 for synchronization. Can we schedule synchronization to happen automatic after every 1 hr etc. Thanks in advance.

    Best regards,
    Usha.
  • kine
    kine Member Posts: 12,562
    1) Use the standard security model and you do not need to solve this anymore...
    2) You can use SYNCHRONIZEALLLOGINS or SYNCHRONIZESINGLELOGIN C/Al commands to run he sync when you need when using Extended sec. mode
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories