Implementing Jet Professional: Server Configuration

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Professional sub-series.

In the last post, I stepped through the installation of the Jet Reports server components; once this has been completed, the next step is to configure the Jet Service Tier via the Jet Administration Console which is accessible via the Windows Start menu in the Jet Reports folder.

Enter the Jet Service Tier Host name and the port selected during the installation of Jet Reports.

Jet Administration Console: Settings

Click the Connect button on the action pane; a dialog confirming the connection was successful should be displayed:

Jet Administration Console: Successfully connected to the Jet Service Tier version 18.0.18060.4

Click OK to dismiss the message.

Click the Users tab which allows additional users to be created as either users or administrators.

To add a user, click the Add button on the action pane:

Jet Administration Console: Users

Enter the name, or part of the name, of the user to be created and click the Check Names button. Click the OK button to accept the selected user:

Select Users or Groups

For each user,a s well as defining the Security Level, you can choose whether they can use a personla data source by marking the Allow Personal Data Sources checkbox.

Click the Sync Active Directory button (it is recommended to do this after making any changes to the users):

Jet Administration Console: Users

Click the Data Sources tab on the navigation pane and then click the Add button on the action pane to create a new data source:

Jet Administration Console: Data Sources

I am creating a Shared data source so only need to complete the firest three fields.

Enter a Name for the data source; this is what the user will see listed in Jet Professional when running the Excel add-in.

Selected a Database Type of Dynamics GP.

Select the Connection Method of On Premises and click the OK button to complete the creation of the data source:

New Data Source

The Data source configuration will be displayed where the more detailed configuration of the data source needs to be completed.

Theer are four sections which need to be configured.

Firstly, there is the authentication which can be either Windows authentication or SQL authentication; for SQL authentication, unmark the Windows authentication checkbox and enter a User name and Password:

Jet Administration Console: Data Sources - Authentication

Regardless of the authentication method selected, access to the Microsoft Dynamics GP database needs to have been granted to the database; I generally recommend using Windows authentication and using a Domain Group rather than individual users when granting permissions to SQL Server.

Click the Connection heading to expand the section.

Enter the full SQL Server Instance name in the Server field; select the system database in the Dynamics database drop down.

The final setting is the Company; this needs to be the name of the company from Microsoft Dynamics GP. Unfortunately this needs to be typed in, rather than selected from a list, and must match exactly the company name in Dynamics GP.

Jet Administration Console: Data Sources - Connection

Click the Display heading to review the default configuration; I’ve not changed any of the settings:

Jet Administration Console: Data Sources - Display

Click the Advanced heading to review the advanced conffiguration; again, I’ve not made any changes:

Jet Administration Console: Data Sources -

Click the Permissions tab and mark the checkbox next to all of the users who should have access to the data source.

Jet Administration Console: Data Sources -

The Jet Administration Console can now be closed.

In this example, I have the admin console installed on the same sevrer running the , but can have it installed on one or more client machines; only users who are administrators can use the console so it does not need to be installed everywhere.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you’d like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) –
Your Email (required) –

Leave a Reply

Your email address will not be published. Required fields are marked *