Error 42S02

ishcatto

We get an error when trying to "Synchronize All Logins". The following is the specific error message:


The following SQL Server error(s) occurred:

208,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid Object name 'TEST 2006$17$3'.

SQL:
GRANT SELECT, INSERT,UPDATE,DELETE ON "TEST 2006$17%3" TO
[$ndo$ar$2B33658647C88EFBEFE27094DCAF7A68]


Does anyone have any idea as to what might be causing this error?
Thanks in advance.

kine

It seems like some problem with SIFT tables for G/L Entry table... Try to disable the keys on this table, save, enable, save to recreate them...

gedas

I guess you use Navision 4.0. Because Navision says you have no permissios for table and point to application role.
In 4.0 Navision creates separate application role for every user, you can see all permissions granted in Navision exist in this role.
For syncronisation user must be in db_owner.
Is it?