Synchronize user login outside navision client

yugi200186

Hi, I really need a quick help here.

Is there a way to synchronize user id in newly restored NAV 4.0 SP3 database from outside the client ?
I'm using NAV 4.0 SP3 paired with SQL Server right now, and i can't login to my newly restored database.
I've already tried create a new id from sql server side but it seems inactive from nav side even if the user id is already existed in the user id table.

NavNab

Hi,

This http://gotcal.com/index.php/2010/10/sql-script-to-create-sa-super-user-in-dynamics-nav/ will help you create a sql user in NAV.
Or this http://navnilesh.blogspot.fr/2014/09/create-windows-login-in-nav-using-sql.html to create windows login user (use the script for NAV 2009)

yugi200186

Forgot to mention, my SQL Server is version 2016.

NavNab

Hi,

This http://gotcal.com/index.php/2010/10/sql-script-to-create-sa-super-user-in-dynamics-nav/ will help you create a sql user in NAV.
Or this http://navnilesh.blogspot.fr/2014/09/create-windows-login-in-nav-using-sql.html to create windows login user (use the script for NAV 2009)

yugi200186

nabil.bamoh@hotmail.com wrote: »

Hi,

This http://gotcal.com/index.php/2010/10/sql-script-to-create-sa-super-user-in-dynamics-nav/ will help you create a sql user in NAV.
Or this http://navnilesh.blogspot.fr/2014/09/create-windows-login-in-nav-using-sql.html to create windows login user (use the script for NAV 2009)

Thanks for the article nabil. This is exactly what i'm looking for.