Hands On with Microsoft Dynamics GP October 2019 Release: Deploy system database

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. As mentioned in the last post, the client installation these days includes the server installation. With one client now 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 SQL Server sa account:

Welcome to Microsoft Dynamics GP Utilities - login

On thw welcome screen, click Next:

Welcome to Microsoft Dynamics GP Utilities

Select the Advanced option on the Installation Options tab and click Next:

Installation Options

Check the locations of the SQL server database files and make any necessary changes; click Next:

Database Setup

The account framework supports a Maximum Account Length of 66 and a Maximum Number of Segments of 10; as I am creating a new demo environment, these are the values I have set. Click Next to proceed:

Set Up Account Framework

Name your segments and set the length and click Next:

Set Up Account Segment Lengths

Decide if you want to sort by other segments. Click Next:

Define Additional Sort Options?

If you opted to sort by additional segments, move the required segments to the Selected Sorting Options list and click Next:

Verify your account framework setup and click Next:

Verify Account Framework

For a new SQL Server, enter a password for the DYNSA user; this is the user you should use post installation for maintenance and security setup. Click Next:

Enter DYNSA User Password

If you are going to be using the web client, mark the Using web client checkbox and then enter a username and password. Click Next to continue:

Web Client SQL Server Login

Select your Authentication Type; as I am using a standard on-premise servers with Active Directory, I have selected Windows Account. Click Next:

If you want a system password, enter the required password (a new feature in Dynamics GP 2018 RTM remembers the system password during a session)) and click Next:

Enter System Password

Review your selections and click Finish to begin deploying the system database:

Once the deployment is finished, you will be prompted to select which Business Intelligence features to deploy. I will revisit this later, so have left both boxes unmarked and just clicked Next:

When you see the Additional Tasks step, choose a task to undertake or click Exit:

Additional Tasks

Click to show/hide the Hands On with Microsoft Dynamics GP October 2019 Release Series Index

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

Leave a Reply

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