Page History

It would be difficult here if the customer/Partner who has already have a good working environment where they have instances running already and face this new challenge when they restored a DB and try connecting the same with NAV service. In this case install from DB would be really hectic to get carried out.

1. If the table is absent try creating the master table using the query as in below.

USE [master]

GO

CREATE TABLE [dbo].[$ndo$srvproperty](

[license] [image] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

2. If the error still occurs, Try running the PowerShell command "Import-NAVServerLicense" to import the license.

3. If still, the error (System table [master].[dbo].[$ndo$srvproperty] is missing or database Demo Database NAV (16-0) is not a Business Central application database.) occurs, it means the table is present and the service or the system flow still checks for a license to be there in the System table [master].[dbo].[$ndo$srvproperty]

then run the below SQL script.

"INSERT INTO [master].[dbo].[$ndo$srvproperty]

([license])

VALUES

((SELECT * FROM OPENROWSET(BULK N'<License File path>', SINGLE_BLOB) as license))".

The above SQL script will inject your NAV license explicitly in your System table [master].[dbo].[$ndo$srvproperty].