[solved] Migrate to SQL Server: Logins

ta5
ta5 Member Posts: 1,164
What steps are recommended concerning Logins when migrating to sql server?

E.g. DB-Logins must be created on sql-server, etc. If so, DB-Logins have a new password after migration!? What about windows logins?

Thanks in advance.

Thomas

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Yes db logins will have new pw. Navision does not store windows logins pw so they will stay the same on SQL. You just have to add the windows users to SQL.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • nunomaia
    nunomaia Member Posts: 1,153
    If you don’t add the logins before the backup, the synchronization will fail, and you have to manually synchronize the logins
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • ta5
    ta5 Member Posts: 1,164
    If I got it right:
    DB-Logins: Add them on the sql server and inform users on new password
    Windows-Logins: No actions to be taken.

    Is this the way to go?
    Thanks
  • nunomaia
    nunomaia Member Posts: 1,153
    yes :D

    The Windows Logins must in the same domain
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • ta5
    ta5 Member Posts: 1,164
    thanks for the info, greatly appreciated!