Hands On With Microsoft Dynamics GP 2016 R2: Deploy System Database

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

in the previous post, the first client was installed; the next step it to deploy the System database.

Do this by launching GP Utilities from the Windows start menu. Log in using the sa account (this is one of the few times when the sa account must be used; at this time there are no other users which can be used).

Welcome to Microsoft Dynamics GP Utilities

On the Welcome step, click Next:

Welcome to Microsoft Dynamics GP Utilities

On the Installation Options step, select Advanced and click Next:

Installation Options

Unfortunately, GP Utilities does not read the default locations for data and log files, so you will need to amend the two Location fields to where you want the system database’s data and log files located. Once the correct folders have been selected, click Next:

Database Setup

The Account Framework needs to be defined; I would always install this with a Maximum Account Length of 66 and Maximum Number of Segments of 10 to allow the most flexibility and allow for the accounts to be made logner in future.

Once you have entered the required values, click Next:

Set Up Account Framework

The length of each segment can be amended; if you selected 66 10 on the previous step, Set Up Account Segment Lengths, each segment will be 6 characters. This should be defined after discussion with the client, assuming you work for a partner as I do.

Once the segments have their lengths defined, click Next:

Set Up Account Segment Lengths

By default, the accounts can be sorted by a number of fields, but you can choose to sort by segments as well. To do so, mark the Yes radio button and click Next:

Define Additional Sorting Options?

Moce the segments you want to sort by to the Selected Sorting Options list using the Add button and click Next:

Set Up Additional Sorting Options

Check and verify the Account Framework is correct; use the Bck button to go back and amke any necessary changes, or click Next to proceed:

Verify Account Framework

Enter a Password for the DYNSA account; this is the Dynamics System Administrator account which should be used to administer Dynamics GP (for full explanation see this post from 2011) and click Next:

Enter DYNSA User Password

If you’re going to be using the Web Client, mark the Using Web Client checkbox and enter the details. I’ll be installing the Web Client later, but have left this option unmarked, as I will do this configuration when I do the web client installation.

Click Next to proceed:

Web Client SQL Server Login

Select your Authentication Type type which can be either Windows Account or Organisation Account if you’re using Azure. I left the option set to Windows Account and clicked Next:

Authentication Type

Enter and confirm the System Password and click Next:

Enter System Password

Confirm your selections and click Finish to begin the deployment of the system database:


Once the deployment of the system database is complete, GP Utilities will move onto the Business Intelligence Report Setup; I have left both of the options unmarked as I will be deploying the BI reports later:

Business Intelligence Report Setup

At the Additional Tasks stage, you can add the sample company or create a company as required.

Additional Tasks

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

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 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) –