Full Syncrhonisation

sabzam
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!!
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!!
0
Comments
-
At first, check that there are no lines in table Member Of for users, which are not existing anymore. Same for table 2000000053.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions