Common Errors related to NAV and Resolution

Normal 0 false false false EN-US X-NONE X-NONE

Error 1. While Synchronizing the security you may get following error:

You do not have the required SQL Server permissions to perform the current security activity.

 

Reason & Resolution:

 

 

Error 2: While Synchronizing the security you may get following error:

 

Microsoft Dynamics NAV Classic
---------------------------
The following SQL Server error or errors occurred:

 

15151,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user '$ndo$ar$000005010500000000000015DCBA5240A7B274A8C47D7F4D00001231', because it does not exist or you do not have permission.

 

SQL:
GRANT SELECT, INSERT, UPDATE, DELETE ON "Object" TO [$ndo$ar$000005010500000000000015DCBA5240A7B274A8C47D7F4D00001231]

 

---------------------------
OK  
---------------------------

 Reason & Resolution: Check if in the "Member of" table there is a user with "Role ID" field BLANK, this can cause the above mentioned error. If the security model is 'Enhanced' then change it to 'Standard'.

Error 3:

 

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
The following ODBC error occurred:

 

Error: [Microsoft][ODBC SQL Server Driver]Database is invalid or cannot be accessed
State ID: HY024

 

---------------------------
OK  
---------------------------

Reason & Resolution:: Database is in Single User mode and more than one session is being attempted. Change the database access mode from "Single User" to "Multi user", which can be done in three ways described HERE [link for other blog]. Though the SQL query will change a little bit:

USE master

GO

EXEC sp_dboption 'DatabaseName', 'single user', 'FALSE';    // Note that True has now become FALSE.

 

Error 4:

---------------------------
Microsoft Dynamics NAV
---------------------------
You do not have permission to run the 'Microsoft Dynamics NAV Server' System.  Contact your system administrator to have your permissions changed.
--------------------------
OK  
---------------------------

 Reason & Resolution: The above error occurs when connecting to RTC and the user's license doesn't have permissions for RTC. Solution to problem is having a license with rights to access RTC client.

 Error 5:

---------------------------
Microsoft Dynamics NAV
---------------------------
The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server due to the following error: Cannot open database "DatabaseName" requested by the login. The login failed.

 

Login failed for user 'DomainName\ComputerName'.
---------------------------
OK  
---------------------------

 

 

Error 6:

---------------------------
Microsoft Dynamics NAV
---------------------------
The TCP/IP connection's 'host' is not answering (TCP/IP error ECONNREFUSED).

 

You can see how to make changes to your 'hosts' and 'services' files in the documentation for the network. Contact your system manager if you need assistance.

 

---------------------------
OK  
---------------------------

 

Error 7: When you try to connect to a SQL Server from some other machine in network/ domain.

Could not find server :

Reason & Resolution:If you are using SQL2005/ 2008, check in SQL Server Surface Area Configuration that Remote Access is enabled.

 

Comment List
Related
Recommended