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.

How to Install Microsoft SQL Server 2017: Avoiding Max Request Length Error in SSRS

Microsoft Dynamics GPIn 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.

In the last post I configured SSRS, which is fine for most uses. However, Microsoft Dynamics GP requires an additional configuration step. This is not done through the Report Server Configuration Manager, but by editing a config file.

The reason this is required is because of an error produced when deploying the SSRS reports. If you do not change the setting, the error you will receive is the following:

GP – The deployment has exceeded the maximum request length allowed by the target server. Set maxRequestLength="20690" in the web.config file and try deploying again.

Microsoft Dynamics GP

The deployment has exceeded the maximum request length allowed by the target server. Set maxRequestLength="20690" in the web.config file and try deploying again.

To avoid this error, requires the SSRS web.config file to be amended. The file, for SQL Server Reporting Services 2017, is located in C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer.

Below is a snippet of code from the web.config file with the added node highlighted:

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" maxRequestLength="20690" />

Add the above, save the file, and SSRS is now ready for the Microsoft Dynamics GP reporting services reports to be deployed.

Hands On With MDGP 2018 RTM: Confirmed – SQL Server 2017 Is Supported

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.

Just a quick post to confirm that Microsoft SQL Server 2017 is supported by Microsoft Dynamics GP 2018 RTM; I currently have Dynamics GP 2018 installing onto SQL Server 2017.

This was the word on the grapevine, but it’s good to see it is the case. I have a couple of implementation projects about to start, where the client is holding off awaiting confirmation. Fortunately, I can now give this on Monday.

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

Hands On With MDGP 2018 RTM: Download the Installation Media

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.

The installation media is now available for download from Microsoft PartnerSource and CustomerSource (relevant login required).

The download process is now cross browser compatible with the retirement, a while ago now, of the ActiveX control which used to be required. The download is now just performed using standard browser protocols.

The file is approximately 1.6 GB in size.

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

Microsoft Dynamics GP 2018 RTM Now Available for Download

Microsoft Dynamics GPI’ve been checking all day, but, finally, the download for Microsoft Dynamics GP 2018 RTM is now available.

You can download it from here (CustomerSource or PartnerSource login required).

You can read about the new features coming in my Dynamics GP 2018 RTM Feature of the Day series of posts.

The Support team will be running a New Feature series of posts starting on 5th December. These blogs will give a comprehensive overview of the features along with excellent content, documentation, and videos, as they have done in the past.

I’ll be going hands on with the new version in a series of posts, probably starting as soon as the download is finished; the posts will start with the installation of the new version, before moving onto covering the new functionality.

Microsoft Dynamics GP 2018 System Requirements Updated to Include Windows 7

Microsoft Dynamics GPMicrosoft Dynamics GP is scheduled for release today, so make sure you review the system requirements to ensure your hardware and software are both compatible with the new version.

Back in July the system requirements for Microsoft Dynamics GP 2018 RTM were released and, at that time, Windows 7 was not supported with any edition, but this version of Windows is now being officially supported with Dynamics GP 2018 RTM.

The system (minimum) requirements for Microsoft Dynamics GP 2018 are now available on CustomerSource (login required):

There are a few versions of OS and software which are not supported with Dynamics GP 2018; the following are not supported in any edition (e.g. Professional, Standard or Enterprise):

  • Windows Server 2008
  • Microsoft SQL Server 2012

How to Install Microsoft SQL Server 2017: Configure SQL Server Reporting Services

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.

In the last post I covered the installation of SQL Server Reporting Services (SSRS); in this post I am going to cover the basic configuration of SSRS.

To complete the configuration, launch the Report Server Configuration Manager; ensure the Server Name is set to the correct name and click the Connect button:

The Report Server Configuration Connection

Continue reading “How to Install Microsoft SQL Server 2017: Configure SQL Server Reporting Services”