Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 309 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Login message SQL2005 NAV50CH permission License
andy76
Member Posts: 616
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
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
0
Comments
RIS Plus, LLC
- 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