I encountered an issue where a SQL Database was in restoring state after a restore operation failed from SQL Management studio UI.
I used the following SQL Script to take the database back to operational state:
RESTORE DATABASE [Database Name]
In Microsoft Dynamics NAV >>> Customer Card, a user enters the value of Bill-To Customer No. on the invoicing tab as the Value of Customer No. on the General Tab, the following error is triggered when user to use the customer:
Error message : “You must not specify Bill-to Customer No. in Customer customer no. = [nn]
Solution is to Clear the Bill-to Customer No., this is because Bill-to customer No. can only be defined where it is different from the customer No. in question.
The Classic client allows attaching a SQL Server database from an .mdf file. When a database is attached this way, permissions to the object tracking table are not set correctly. The user under which the Microsoft Dynamics NAV Server service is executed needs permissions to this table. The service stops responding when you try to start the RoleTailored client, and the event log reports that access to the object tracking table was denied.
Resolution – Workaround
- Stop the Microsoft Dynamics NAV Server service.
- Stop the SQL Server service.
- Open a command prompt.
- At the command prompt, type the following command:
Sqlcmd -d “Demo Database NAV (6-0)” -q “GRANT SELECT ON [dbo].[Object Tracking] TO [NT AUTHORITY\NETWORK SERVICE]”
- Start the SQL Server service.
- Start the Microsoft Dynamics NAV Server service.
An alternative to taking screenshot of an error message generated by Dynamics NAV is to copy the text. This can be achieved by using keyboard shortcut CTRL + C (Copy) on the Error. This is ideal for copying and pasting error messages when raising a support query where screenshot capture is not possible.
Select the error, CTRL = C , Paste (CTRL + V )
Microsoft Dynamics NAV Classic
There is nothing to post.