There are no NAV Server Instance available for this database

There are no NAV Server Instance available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity.

Solution: -

• Go to your SQL Server (SSMS).
• Check your Database name and copy database name.
• Go to Dynamics NAV Administration.
• Select your Instance and click on Edit button.
• Go to Database.
• Select your database name box.
• Paste your copied database name.
• Click on Save button.
• Restart your NAV Instance Service.

You do not have access to Microsoft Dynamics NAV.

You do not have access to Microsoft Dynamics NAV. Verify that you have been set up as a valid user in Microsoft Dynamics NAV.

Solution: -

• Go to SQL Server (SSMS).
• Click on New Query.
• Select your database.
• Put the 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]

• Click on Execute button.
• Restart NAV Instance service.