Login message SQL2005 NAV50CH permission License

andy76
andy76 Member Posts: 616
edited 2007-08-24 in SQL General
Hello,

I have the following message when I log in in NAV5.0 with SQL Server 2005 with windows authentication in the case the Windows User has not SUPER role.

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The select permission was denied on the object 'MYDB$License Agreement', database 'MYDB', schema 'dbo'.

I inform you that if to the same user I add the role super I don't have this message and it works fine.

NAV5.00 CH

I am quite new to Navision but it would seem that for SQL I have to add some particular role : ALL and P&P-VENDOR are not enought?

Thank you

Andy

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Did you synchronize all users?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • andy76
    andy76 Member Posts: 616
    Yes, I have syncronized all users. I am sure of this thing
  • andy76
    andy76 Member Posts: 616
    The ways to solve this message are:

    - from Navision:
    - assign the navision user (windows authentication) the role SUPER
    OR
    - assign the navision user (windows authentication) the role SUPER(DATA)

    - from SQL Server 2005:
    - assign the user SQL (windows auth) the server role sysadm
    OR
    - assign the user SQL (windows auth) the Database Role dbowner

    Is it possible that there are these restrictions/prerequisites? :-s :-k
    I tried all combinations and these are the only one allowed.

    Thank you

    Andy

Categories