Options

Full Syncrhonisation

sabzamsabzam Member Posts: 1,149
Hi Everyody,

I am trying to fully-syncrhonise the windows-login users in an sql db. For some reason the following error is croppin gout:

The following sql server error occured:
4604,42000, [Microsoft][ODBC SQL Server Driver][SQL Server]There is no such user or group '$ndo$ar$'

SQL: GRANT SELECT ON 'XXXXX' to [$ndo$ar$]

Kindly note that xxxx is the compnay name and table. The strange part is taht I've gone throught all the users and didn't find any similar user registered. Has anyone ever met such an issue and managed to solve it?

Regards!!

Comments

  • Options
    kinekine Member Posts: 12,562
    At first, check that there are no lines in table Member Of for users, which are not existing anymore. Same for table 2000000053.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.