Login message SQL2005 NAV50CH permission License

andy76

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

DenSter

Did you synchronize all users?

andy76

Yes, I have syncronized all users. I am sure of this thing

andy76

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