Hands On with Microsoft Dynamics GP 2018 R2: Deploy System Database

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

With the first first client now installed we need to deploy the server objects.

Back in the day, there was seaprate server and client compenents, but this changed with Microsoft Dynamics GP 10; now the server objects are deployed from a client install. To deploy the server components, start GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

On the Welcome screen, click Next:

Welcome to Microsoft Dynamics GP Utilities

Select the option of Advanced and click Next:

Installation Options

The Location fields will not default to the correct values (or at least they never do for me), so enter the correct paths and click Next:

Database Setup

When installing Dynamics GP, I wlasy set the Maximum Account Length to 66 and the Maximum Number of Segments to 10; this gives the maximum size available for the account strings. While you might not need this initially, it gives plenty of scope for growth.

Click Next to proceed:

Set Up Account Framework

Enter Names for the segments and click Next:

Set Up Account Segment Lengths

Choose whether you want tod efine additional sorts (I have opted for No; if you select Yes there will be another step after this where you select the additional sorts.

Click Next:

Define Additional Sorting Options?

Verify the account framework and click Next if you’re happy to proceed:

Verify Account Framework

Enter and confirm the password for the DYNSA account and click Next:

Enter DYNSA User Password

If you’re going to be installing the web client, as I am, mark the Using web client checkbox and enter the user credentials which are to be used for the web client proxy account. Click Next:

Web Client SQL Server Login

Select your Authentication Type; I am using the default of Windows Account as I am installing this on a local Windows server:

Authentication Type

Enter and confirm a System Password and click Next:

Enter System Password

Review your selections on the Confirmation step and click Finish:


I am not marking any boxes on the Business Intelligence Reports Setup step as I will handle this later. Click Next to proceed:

Business Intelligence Reports Setup

The next shown step is the Additional Tasks one; I will be adding the sample company data, but will do this in the next post:

Additional Tasks

Click to show/hide the Hands On with Microsoft Dynamics GP 2018 R2 Series Index

Can ISC Software help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you would 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

Your Email


Your Enquiry

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

1 thought on “Hands On with Microsoft Dynamics GP 2018 R2: Deploy System Database

  1. Pingback: Comment

Leave a Reply

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