"TableData 2000000001 dose not exist"

AST

hello, I use Navison 4.0 SP2, Sql Server 2005 and Database Server Authentication. I created logins (using Sql server tools) without any server role. Then I created user1 and user2 inside Navision. User ID in database logins are correct.
I can log in User1 (role Super), but when I try to log in User2 (All role) I receive message "TableData 2000000001 dose not exist". What should I do?
Thanks in advence.

ara3n

table 2000000001 is the object table.
add the table to all role and synchronize security. The other option is to upgrade to sp3 executable and use the standard model security.

flastuart

I would definately not recommend SP2 with SQL 2005. You will run into all kinds of problems. Just use SP3 and all will be right with the world.

vyanku

I think in system tables u defind any veriable in C\CAL global
Delete that global verisble.

AST

I would definately not recommend SP2 with SQL 2005. You will run into all kinds of problems. Just use SP3 and all will be right with the world.

Could you list some of this problems?
Thx

flastuart

While doing testing on using the .exe for SP2 and SQL 2005, a user who was a super user had no issue, but someone with limited access, had error message after error message about some table not existing or could not read some table. Also, the security synchronization took forever. In SP3, all those issues were gone.