ADD LOGIN IN NAV 2009 / SQL

Business Central/NAV User Forum
1

HI

I CREAT THE LOGIN IN SQL AND ITS APPEAR IN DATABASE AS OWNER AND PUBLIC ROLE

BUT WHEN I TRY TO ADD IT IN NAV ITS REFUSED WITH THIS MESSAGE . The Microsoft Dynamics NAV Classis and SQL Server security systems have not been successfully synchronized." The SQL Server login XXX does not exist on the SSS server.

NOTE THAT THE SYNCHRONIZE SINGLE LOGIN ITS OK FOR THE EXISTING LOGIN BUT SYNCHRONIZE ALL ITS NOT WORK

THANKS FOR ANY ONE

2

Hi AEKMEN,

Go to relevant SQL Server login properties and check whether login was mapped with related database.

3

hi

i have checked this this property before so

i tried another thing, i use the sa login end then i was able to do the sync all and add a new user in nav; so i go to sql and give the “super user” a “securityadmin” role on the server role so now when i log with super in nav i have no problem to sync an add new user

thanks