9 Feb’18

D365 Business Central

Error resolution to 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”

Introduction:

When we restore the SQL database from one server to the other server and when we launch the Microsoft Dynamics NAV RTC, we 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”. This blog article gives the steps how to resolve this error.

Pre-requisites:

  • Microsoft Dynamics NAV
  • SQL Server Management Service(SSMS)

Reason for the error:

When an SQL backup is restored from one server to the other, even the Windows users created in the previous server is restored to the new server which is not present. Hence, the error is thrown.

Steps:

1. Open SSMS and select the database restored.
2. Click on new query and type in the below query.

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]

3. Enter the database name and click on execute.

4. Now restart the server instance and launch the Role Tailored Client(RTC) and make sure a windows user is made in  users in the RTC.

Written by

Chris D'Silva

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • How to Run Reports when report processing takes long to cause Session Time-out

    12 July’ 2019

    Introduction: I’ve observed that when NAV is used for a very long time, the report which needs heavy processing ta...

    Read more
  • First Canvas Power App: Learn Few Easy and Important Commands

    11 July’ 2019

    As my thoughts build to initiate writing this blog, similar was the feeling when I first thought about exploring Power A...

    Read more
  • Tips to Solve your Infinite Loop Issue

    3 July’ 2019

    While using fetch xml to retrieve records more than 5000 records and if you have multiple entities involve in it. There ...

    Read more
  • Deploy Dynamics 365 Operations Environment using Lifecycle Services – Part 2

    2 July’ 2019

    In this article, we will take look at the post configuration setting for Finance and Operations environment.You can lo...

    Read more
  • Shift/Statement posting error in Microsoft Dynamics 365 For Retail

    1 July’ 2019

    In this blog I am going to  demonstrate how to deal with errors generated during statement posting. At times while you ...

    Read more
  • We respect your privacy.
  • This field is for validation purposes and should be left unchanged.