you have not access to microsoft dynamics nav verify that you have been set a valid user in Microsoft Dynamics Nav

Hello, i just restored a database from my friends, And i got a problem which show me an error you have not access to microsoft dynamics nav verify that you have been set  a valid user in Microsoft Dynamics Nav, But in the develop environment, I can connect to hte database. Any suggestion ? thanks very much.

  • In that Restored database Your Local Computer User not created.
  • You need to execute query on sql. In that query all Users deleted from database.

    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]
  • In reply to kalyantupe45:

    THANKS, LET ME TRY.
  • In reply to kalyantupe45:

    thanks , it works... Much appreciated.
Related