Creating new db on sql server Error

ara3n

Hello ran into this issue today and resolved it. Didn't find any info on this on mibuso or MS.
Client had an older version of Nav on sql but removed it and I was trying to installed Navision 5.0 Sp1.
The Error we were getting is

The database on the SQLNAME server does not contain Microsoft Dynamics NAV system objects and cannot be opened.



I turned on query profiler to see what nav db was doing and it was querying the $ndo$srvproperty table. The table was empty (NULL) and did not have a license.

I deleted the table and was able to create a new database.

kine

It looks like the previous DB was using "license per database". New DB you wanted to create was without this property or something like this... but it is just my brainstorming... 8)

ara3n

I just think it's an odd error. Regular users would probably never find out what the problem is.

And what are Microsoft Dynamics NAV system objects on a sql server?

kine

ara3n wrote:

And what are Microsoft Dynamics NAV system objects on a sql server?

E.g. $ndo$srvproperty in master database... ;-)

ara3n

those aren''t objects but a simple license file. The error could state that.

Are there any other system objects?

kine

No outside the NAV DB (excluding the extended stored procedures...)...

ara3n

well the error could then simply state that.

The error should be something like this. The table $ndo$srvproperty does not have a license or is NULL.