Web Client Business Central 2020

(0) Share

Report

Posted on by Galina Georgieva

194

Hello,

I have installed Business Central 2020 Wave 1 and after starting the web client I get the following error message:

"The following SQL error was unexpected: Invalid object name 'master.dbo.$ndo$srvproperty'"

How to resolve this problem?

I have the same question (0)

All responses (15)

Answers (3)

Rohansilva 35 on at

Like (0)

Report

Did You check whether this table ('$ndo$srvproperty') available in your master DB?

Cheers

Rohan Silva

Was this reply helpful? Yes No
Galina Georgieva 194 on at

Like (0)

Report

Yes, I checked and the table is missing.

Was this reply helpful? Yes No
Verified answer

Rohansilva 35 on at

Like (1)

Report

try Creating it

USE [master]

GO

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

[license] [image] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

Was this reply helpful? Yes No
Galina Georgieva 194 on at

Like (1)

Report

Thank you.

I created the table but now I get the error:

System table [master].[dbo].[$ndo$srvproperty] is missing or database Demo Database NAV (16-0) is not a Business Central application database.

Was this reply helpful? Yes No
Galina Georgieva 194 on at

Like (0)

Report

I also noticed that after creating $ndo$srvproperty table it is not located in the System tables folder on the master database. Is this a problem?

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

What happens if you try to import the license file via PowerShell into the database?

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You haver restored de DB from SQL, or create from DVD whit the instalation wizard?

Try to reinstall, and mark the chek that creat de Cronus DB.

Was this reply helpful? Yes No
Suggested answer

Salah Eddine BENOUALA 485 on at

Like (0)

Report

Hi Galina,

Did you import the flf file license first ?

Try importing license and restart the service.

-----------------------------------------

Best Regards,

Salah Eddine BENOUALA

Dynamics NAV & 365 Business Central Consultant

Please verify my answer, if you find it helpful.

Doing so you'll show others that there was found a solution and you credit my help.

Was this reply helpful? Yes No
Galina Georgieva 194 on at

Like (0)

Report

Hello,

I get the same error:

Import-NAVServerLicense : System table [master].[dbo].[$ndo$srvproperty] is missing or database Demo Database NAV (16-0) is not a Business Central application database.

Was this reply helpful? Yes No
Galina Georgieva 194 on at

Like (0)

Report

Hi,

I have restored the database from SQLDemoDatabase folder from the installation DVD.

Was this reply helpful? Yes No