Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Navision Windows login not authenticating
dmlee
Member Posts: 2
Hello all,
Last week couple of our Navision Windows Login users lost connection to Navision. They are getting the below error when they try to log in:
"15161, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot set application role '$ndo$ar$000...' because it does not exist or the password is incorrect
I've tried to resynch the Windows users in Navision but got the below SQL error during resynching:
"15151, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user '$ndo$ar$000...' because it does not exist or you do not have permission.
SQL:
Grant select on "[database table name]" to'$ndo$ar$000...'
These users are Windows users and should be pulling credentials from Active Directory. I've created a new Navision Windows user and am getting the same above error during synching.
The problem only impacts the Navision Database, it does not impact other databases on the same server.
There have been no change to database or server. We are running Nav 5 database and Nav2009 client on SQL server 2005 and Windows Server 2003.
Any help would be greatly appreciated.
Last week couple of our Navision Windows Login users lost connection to Navision. They are getting the below error when they try to log in:
"15161, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot set application role '$ndo$ar$000...' because it does not exist or the password is incorrect
I've tried to resynch the Windows users in Navision but got the below SQL error during resynching:
"15151, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user '$ndo$ar$000...' because it does not exist or you do not have permission.
SQL:
Grant select on "[database table name]" to'$ndo$ar$000...'
These users are Windows users and should be pulling credentials from Active Directory. I've created a new Navision Windows user and am getting the same above error during synching.
The problem only impacts the Navision Database, it does not impact other databases on the same server.
There have been no change to database or server. We are running Nav 5 database and Nav2009 client on SQL server 2005 and Windows Server 2003.
Any help would be greatly appreciated.
0
Comments
Try to set Default database on User login property in SQL Server and also give them Master DB permission as well.
Hope this will work.