Sunday, January 4, 2015

Error : You do not have access to Microsoft Dynamics NAV.


Hi all,

In dynamics NAV , you might have faced a problem with log in to NAV RTC.

The error is 



Mainly, this error will occur because of the user permissions. 

For my experience, when we create a user in dynamics NAV, the system will not allow other users to 
login and will appear above error.

To avoid this issue we can manually delete the users from MS SQL and retry to login the NAV.


USE [YourNAVDatabase];  
 delete FROM [dbo].[Access Control];  
 delete FROM [dbo].[User];  
 delete FROM [dbo].[User Property];  
 delete from dbo.[User Personalization];  
 delete from dbo.[User Metadata];  
 delete from dbo.[Page Data Personalization]; 





Restart the NAV service and try to login to the Dynamics NAV.




Thank you.

Regards,

Dinuka

No comments:

Post a Comment