Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company

Microsoft Dynamics GPWith the system database deployed it is now time to deploy the sample company. This is done by launching GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

On the Welcome screen click Next:

Welcome to Microsoft Dynamics GP Utilities

A check will be performed to ensure the database version matches the GP Utilities version. After confirming this check has been successful, click Next

Update Microsoft Dynamics GP

The next stage displayed will be the Additional Tasks one; leave the drop down list set to Add sample company data and click Process:

In line with changing the system database name to D16R1 I have changed the database name of the Fabrikam sample database to T16R1. As mentioned when deploying the system database, GP Utilities does not set the Location fields to the default locations specified when SQL Server was installed, but to the install folder of SQL Server. Amend these fields to the required locations and click Next:

Database Setup

Check the settings on the Confirmation screen and, if happy, click Finish:

Confirmation

Once the database has been created and all SQL objects deployed, the next step is to select which BI reports should be deployed. I am deploying both so have marked both the Microsoft SQL Server Reporting Services reports and Microsoft Excel reports and data connections checkboxes:

Business Intelligence Reports Setup

The settings on the SQL Server Reporting Services Reports Setup will default to those configured when deploying the system database. Verify the settings are correct and click Next

SQL Server Reporting Services Reports Setup

Likewise the settings for the Excel Reports Setup will default in, so click Next:

Excel Reports Setup

Check the selections on the Confirmation screen and click Finish to deploy the BI reports (if you are working with a new SQL Server make sure the maxRequestLength setting in SSRS has been set to 20690 before clicking Finish):

Confirmation

Once the reports have been deployed you will be returned to the Additional Tasks screen. Click Exit:

In the next post I’ll cover the creation of a new company.

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R1 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.