Friday, December 25, 2015

Error: You are not authorized to sign in. Verify that you are using valid credentials and that you have been setup as a user in Microsoft Dynamics Navision.

error you are not authorized to sign in microsoft dynamics nav 2013 r2

In Navision 2013 R2, we are using Role Tailored Client (RTC) for client usage different from previous versions.

The reason for the error,   “You are not authorized to sign in. Verify that you are using valid credentials and that you have been setup as a user in Microsoft Dynamics NAV” is the unavailability of windows login in our NAV database.

Run these following commands to resolve the issue:

1. Open ‘SSMS’ with ‘SA’ or ‘Super’ credentials.
2. Go to ‘Databases‘ and select your respective database.

3. Right click on that database and select ‘New Query’.

4. Run these following commands


USE [Database Name]

GO
delete from [dbo].[User]
delete from [dbo].[Access Control]
delete from [dbo].[User Property]
delete from [dbo].[Page Data Personalization]
delete from [dbo].[User Default Style Sheet]
delete from [dbo].[User Metadata]
delete from [dbo].[User Personalization]

5. Open ‘Microsoft Dynamics NAV Server Administration Tool.

6. In Navision service credential select start as Network Service’.

7. Restart Instance for updation of changes.

8. Restart ‘Microsoft Dynamics NAV Role Tailored Client.

9. Then create your ‘System ID’ in RTC for future use.



Enjoyed the topic, Please do subscribe to our newsletter to get updated with every post without a miss.


Thanks for reading

Shubin Dongre



1 comment:

  1. you can use either way.

    1. Open ‘SSMS’ with ‘SA’ or ‘Super’ credentials.
    2. Go to ‘Databases‘ and select your respective database.

    3.Go to user setup and create user setup for the user who find the error "You are not authorized to sign in. Verify that you are using valid credentials and that you have been setup as a user in Microsoft Dynamics NAV".

    Issue will be resolved.

    ReplyDelete