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

  • DenSterDenSter Member Posts: 8,307
    Tools, Security, Synchronize all logins
  • 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.
  • 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.