There are 2 accounts used for authentication as follows: In this setup, a direct SQL connection is being made to the database. It is a requirement to setup a Dynamics NAV Password for this AD Group “User”, and this will be used by Jet Reports for authentication. When logging into NAV/BC client, the application will recognize whether a user is a member of a group and apply the appropriate permissions. The permission sets and User Groups are setup against this user card. This is because there are no Permission Sets or User Groups assigned directly against this user.Ī user card is setup in NAV/BC for the Active Directory Group. If Jet Reports is setup to connect directly to SQL and with the Windows Current User as the account for the roles and permissions, the following error will be seen. Note that the user is not assigned any permission sets or User Groups directly. The screenshots in this example are based on local groups, but the principle is the same.Ī group is setup, with one or more windows users as members. This document describes the necessary configuration for Jet Reports if you are managing the security in your NAV or BC environment by Active Directory Security Groups.
0 Comments
Leave a Reply. |