Problem
NAV license table is missing, an error occur when an error show $ndo$srvproperty table is missing or no access right to related table
Solution
Use SQL server management studio to create the related table in MASTER db
USE [master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[$ndo$srvproperty](
[license] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
USE [master]
GO
CREATE LOGIN [domain\accountname] FROM WINDOWS
CREATE USER [domain\accountname] FOR LOGIN [domain\accountname]
GRANT SELECT ON [master].[dbo].[$ndo$srvproperty] TO [domain\accountname]
ALTER SERVER ROLE [dbcreator] ADD MEMBER [domain\accountname]
GO
More
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].
3. Used NAV development environment to upload the license and noticed the table was automatically created.
Related articles
There is no content with the specified labels