No company in NAV 5.0 sp1

maris2000

Hi,
I have just created database on NAV sql client.
When I open a company in NAV I cannot see anything, but on SQL server I can see all the tables and companies.
I'm running windows vista business, nav 5.0sp1 and sql express 2005.
I cannot see what could be wrong.

garak

check under SQL if the table Company has a value

hardik_shah

Please check your licence file....OR might be problem with Rights

maris2000

The company table is not empty, it has 3 records for the 3 companies.
I don't think that licence is problem.

maris2000

This is annoying.
Can anybody explain how to create new databases in Nav5.0sp1 with Microsoft SQL server option.
Step by step

garak

a real new one without an existing backup?

maris2000

a new one with existing backup

garak

is it a native backup oo a sql backup?
If native backup (fbk), is this form a native database?

kine

It seems that you are missing objects in the database. Probably they were not included in the backup or you restore the database which was not clean (already created objects or company inside, existing user accounts etc.).

garak

Probably they were not included in the backup

to be sure, if the backupfile (fbk) includes all object, you can use the fbk to import objects.
Open the object designer -> File -> Import -> select the fbk -> wait some times -> Import the objects

maris2000

thank you all for your help.
licence was a problem.
sorry to inform you first now. i was very bussy.
thank you once again