db_owner and posting error

fufikk
fufikk Member Posts: 104
edited 2013-07-16 in NAV/Navision Classic Client
Hi,

I'm facing a bit odd problem with finishing and posting prod. order: I get error message that Item Register xxx does not exist.

Little backgroud first: SQL server is 2012, NAV is 3.7 running with 5.0 client. Database has been moved recenlty from old server (don't know which version though).

There are 2 users: U1 (super & db_owner), U2 (SUPER, no db_owner, just public).

U1 is able to finish & post production order, while the other one can't. Sadly, I have no clue why that happens and I hope for your assistance.

Taking the easy way out and adding db_owner to everybody is not something I'd like to do... unless there is no other option.

Thanks in advance.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Check the security mode? Make sure it's set to standard.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • fufikk
    fufikk Member Posts: 104
    I did the check with my admin user and yes, security model is set to standard.

    Interesting thing happened when checking the setting with user who is SUPER but not db_owner, I got this error:
    The following ODBC error occurred:

    Error: [Microsoft][ODBC SQL Server Driver]Database is invalid or cannot be accessed
    State ID: HY024
  • ara3n
    ara3n Member Posts: 9,258
    Is client 5.0 compatible with sql 2012?

    Also was the db upgraded from an older sql version through sql backup?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • fufikk
    fufikk Member Posts: 104
    ara3n wrote:
    Is client 5.0 compatible with sql 2012?

    I'm not 100% sure about that. On the other hand I haven't found anything that would say it isn't. Besides that particular posting problem I haven't heard of any other problems.

    ara3n wrote:
    Also was the db upgraded from an older sql version through sql backup?

    That I don't really know. However, yesterday I googled out someones problem with option caption string being slightly different that option string for Object Type field in Permission table. I checked it here as well to find out that there was no option caption for XMLPort for example. I'm not sure what to do with that knowledge right now, but I do remember a case from some time ago, where replacing existing tables in 2000000xxx range with "original" ones from target client version solved some problems.

Categories