$ndo$srvproperty object is missing

Hi Experts,

I was trying to configure SQL server and NAV in the live DB, but after installing SQL server and restoring database, I noticed $ndo$srvproperty table is missing. Without this table, I could not create a NAV user using the command lines.

Prior to this, I did the same step in VM, but had no issue with this table showing up. But I am not sure why this table is missing here in live.

Please kindly share your knowledge or any expertise. Greatly appreciated!

pastedimage1513294952897v1.png

pastedimage1513294969728v2.png

The $ndo$srvproperty is used to store your NAV license file. You will not find it in master if you have selected “Per Database License” in the NAV “Per Database License” configuration.

So I assume that you have moved the database from a server where this configuration was not used.

I never had the error my self, but I assume that you will need to connect to your database using C/SIDE and upload your license.

Hi Erik,

Thank you very much for your reply.
I used NAV development environment to upload my license and noticed this table was automatically created.
Then after I created myself as a user, I could open NAV now.
Thank you so much for your help!