User creation error in NAV2009SP1

kish2007

Dear All,

we are using NAV 2009 SP1. i created new user ABC in sql server. when i creating the user ABC in FINSQL iam getting the below error.

" The Microsoft Dynamics NAV Classic and SQL server security systems have not been successfully synchronized.
The SQL server Login ABC does not exist on the 192.168.0.4 server.

when i click synchronize all logins in FINSQL iam facing the same error. but it is synchronising each user wise with out errors.

How to resolve this error.



Regards,
kishore..

ara3n

What security mode do you have the db set? I suggest to set it to standard.
Also the person doing the syncing, are they logging in as SA?

kine

And is the user ABC created as database user on the SQL server and not Windows user?

kish2007

Thanks for your valuable replies. when i logined with SA the problem was resolved.


Regards,
kishore...

ara3n

You are welcome.

rmpatel22

We have SQL Server database with "Advanced" security mode, and we were facing problem in adding new users in Navision.

Today I found this thread and logged in with sa in Navision and created users, it worked fine.

So if security mode is "Advanced", only sa user can add more users in Navision(Even super can't add more users in Navision)

Thanks ara3n and other Mibuso contributors.

ara3n

you are welcome.