Options

Synchronization of logins between Nav 2009 and Sql server

usha2009usha2009 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

  • Options
    DenSterDenSter Member Posts: 8,304
    Tools, Security, Synchronize all logins
  • Options
    usha2009usha2009 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.
  • Options
    kinekine 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.
Sign In or Register to comment.