Hands On With MDGP 2018 RTM: Before Deploying the Reporting Services Reports

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

Now that Microsoft Dynamics GP 2018 RTM has been installed and confirmed working, it’s time to deploy the Reporting Services Reports. However, before I do so, there are two tasks which need to be done first.

The first is to ensure SQL Server Reporting Services itself has been configured to work with Microsoft Dynamics GP. This isn’t actually too difficult, it just requires the following element to be added to the web.config file:

maxRequestLength="20690"

This blog post has detailed instructions of how to make this configuration change.

The second change may not be needed; it will depend on the security settings on your PC or server, but I find myself making this change in advance anyway so that I do not have any issues and so that my AD login is automatically used. When I don’t make this change, I have had problems deploying the reports; when I make the attempt, the deployment hangs and eventually fails.

The change is to add the SSRS website to the Local Intranet zone. To do this, launch Internet Explorer, clikc the cog icon and then select Internet options:

Internet Explorer

Continue reading “Hands On With MDGP 2018 RTM: Before Deploying the Reporting Services Reports”

Cashbook Bank Management (1058) Added to GP Table Reference

GP Table ReferenceI’m in the process of preparing to update the GP Table Reference for Microsoft Dynamics GP 2018 RTM, but have had some data almost ready to add for a while. Unfortunately, I’ve not had time to do it until now.

Hopefully the 2018 update will be done soon, but in the meantime I have added the Cashbook Bank Management (Product ID 1058) tables to the site.

Hands On With MDGP 2018 RTM: Desktop Client First Run

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

Now that there are companies available, we can log into the client and test that it is working correctly.

Launch Microsoft Dynamics GP 2018 RTM using the GP shortcut and log in using the DYNSA user:

Welcome to Microsoft Dynamics GP

Continue reading “Hands On With MDGP 2018 RTM: Desktop Client First Run”

Hands On With MDGP 2018 RTM: Create A Company

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

As well as deploying the sample company, I always deploy a second company into which I will restore a copy of Fabrikam; this allows Intercompany to be configured and demonstrated when necessary.

To create a new company, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP

Continue reading “Hands On With MDGP 2018 RTM: Create A Company”

Hands On With MDGP 2018 RTM: Deploy Sample Company

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the system database deployed, the next step is to deploy the Fabrikam, Inc. sample company.

To do this, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With MDGP 2018 RTM: Deploy Sample Company”

Hands On With MDGP 2018 RTM: Deploy System Database

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the client now installed, I am able to progress to using GP Utilities to deploy the system database, the name of which was defined on the SQL Server step of the client install.

To deploy the system database launch GP Utilities and log in using the SQL Server system administrator (sa) account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With MDGP 2018 RTM: Deploy System Database”

Hands On With MDGP 2018 RTM: Install Dynamics GP Client

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the .NET Framework 3.5 prerequisite installed, it is time to install the Microsoft Dynamics GP 2018 RTM client software; depending on the software you’ve used before, it might seem counter-intuitive to start with client software, but Microsoft Dynamics GP hasn’t had dedicated server components for some time now. The server components are installed using GP Utilities which is installed alongside the client version of the software.

I am doing this installation on a brand new test system which has multiple single use servers; the two servers involved in the client installation is the SQL Server, called 2018SQL1, which hosts a named instance of SQL Server 2017 (which is supported despite the current system requirements documentation) and a terminal server called 2018TS1 running Windows Server 2016.

Unzip the downloaded installation media and run the Setup.exe.

Depending on server settings, you might receive multiple security warnings during the installation; click Run on each one as it appears:

The Microsoft Dynamics GP 2018 Bootstrapper Setup will start; click Install to install the prerequisites:

Microsoft Dynamics GP 2018 Bootstrapper Setup

Once the prerequisites have been installed, the installer screen will display. In the Install section at the top, click on Microsoft Dynamics GP and then click Install on the popup menu:

Microsoft Dynamics GP 2018

Continue reading “Hands On With MDGP 2018 RTM: Install Dynamics GP Client”

Hands On With MDGP 2018 RTM: Installing the .NET Prerequisite

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

Before Microsoft Dynamics GP 2018 RTM, or any of the related additional products, can be installed there is one prerequisite which cannot be handled by the installer process. This is the .NET Framework 3.5 feature which is installed using the Add Roles and Features Wizard available via Server Manager on Windows Server or using Turn Windows features on or off accessible via Program and Features on Windows.

If the PC or server you’re planning to install Microsoft Dynamics GP 2018 RTM onto has an Internet connection, then the .NET can be installed simply by using the wizard. However, if, for whatever reason, you don’t have an Internet connection available, the install process isn’t quite that smooth.

On both server and PC you can do an offline install and I have blogged about this previously:

  1. Offline install on Windows.
  2. Offline install on Windows Server.

Both of the above posts were for previous versions of Windows, but both are still relevant for the later versions.

Click to show/hide the Hands On With MDGP 2018 RTM Series Index

GP Power Tools Updated for Microsoft Dynamics GP 2018 RTM

Winthrop DCWith the recent launch of Microsoft Dynamics GP 2018 RTM, the ISVs are releasing updated versions of their add-ons for the new version.

One of these, Winthrop DC, has a product called GP Power Tools (GPPT) which I was blogging about earlier in the year.

Winthrop have announced that GPPT and their other products (Batch Posting Service Toolkit and Visual Studio Integration Toolkit) have all been updated for the Microsoft Dynamics GP 2018 RTM version.

How to Install Microsoft SQL Server 2017: SSRS 2017 Not Supported on a Domain Controller

Microsoft SQL ServerIn this short series of posts, I am going to be covering the installation of Microsoft SQL Server 2017; the installation process for this version is somewhat different to previous ones, in that SQL Server Management Studio and SQL Server Reporting Services have been separated out from the main installer.

The series index can be found here. I am not a SQL expert and this series of posts is intended only for use on demo or test environment and not production ones.

I often create two types of demo or test environment; one will have multiple virtual machiens createdin order to replicate a typical live environment, and the second has only a single virtual machine.

While prepping a test environment of the latter type in readiness for the launch of Microsoft Dynamics GP 2018 RTM, I encountered a problem with SSRS:

Microsoft SQL Server 2017 Reporting Services installation issue

Microsoft SQL Server 2017 Reporting Services

Setup blocked

The following issues blocked Setup

Installing Reporting Services on a domain controller is not supported

This is a major departure from SQL Server 2016 and previous, all of which allowed SSRS to be installed on a Domain Controller; for most systems this will be absolutely fine, but I’ll no longer be able to use single virtual machine demo or test environments.