Hands on with the Microsoft Dynamics GP Fall 2020 Release: Deploy system database

Microsoft Dynamics GPThis post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release.

With the client installed, the next step is to deploy the system database. Do this by launching GP Utilities from the Windows Start menu and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Click Next on the Welcome step:

Welcome to Microsoft Dynamics GP Utilities

Select the Advanced radio button and click Next:

Installation Options

Set the Location for the data and log files on the SQL Server and click Next:

Database Setup

When installing Dynamics GP, I always do so using the maximum lengths possible for the account length and number of segments; set the Maximum Account Length to 66 and the Maximum Number of Segments to 10; click Next:

Set Up Account Framework

On the Set Up Account Segment Lengths, you can set the maximum length of each segment as well as setting a Name for each. When finished, click Next:

Set Up Account Segment Lengths

Decide if you want to be able to sort by segments other than the first and click Next:

Define Additional Sorting Options?

If you answered yes on the previous step, add the Available Segments to the Selected Sorting Options list and click Next:

Set Up Additional Sorting Options

Check the settings for the account framework are correct and click Next:

Verify Account Framework

If using the web client, mark the Using web client checkbox and enter the login details for the proxy account; click Next:

Web Client SQL Server Login

Select the Authentication Type to use; Windows Account will use your local Active Directory while Organizational will prompt for the Azure details. Click Next:

Authentication Type

If required, enter a System Password and click Next:

Enter System Password

Check the selected settings are correct and click Finish to begin the deployment of the system database:


I am not going to deploy any of the Business Intelligence options on this system, but if you are, I have previously covered the deployment of the Reporting Services and Excel reports. Click Next:

Business Intelligence Reports Setup

When the Additional Tasks window is displayed, you can choose to add the sample company or create a company:

Additional Tasks

In the next couple of posts, I will cover both the adding of the sample company and creation of a company.

Click to show/hide the Hands on with the Microsoft Dynamics GP Fall 2020 Release 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) –

Leave a Reply

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