"TableData 2000000001 dose not exist"

AST
AST Member Posts: 108
edited 2007-05-02 in NAV/Navision Classic Client
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.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • flastuart
    flastuart Member Posts: 12
    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
    vyanku Member Posts: 791
    I think in system tables u defind any veriable in C\CAL global
    Delete that global verisble.
  • AST
    AST Member Posts: 108
    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
    flastuart Member Posts: 12
    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.

Categories