Workflow 2.0 Requires Display Names for AD Groups Used as Approver

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPMicrosoft Dynamics GP supports the use of both Active Directory Groups and Users as approvers, but there is a minor catch in the creation of groups which it is easy to stumble over. If you create the group as usual via the Active Directory Users and Computers applet you set a Group name and Group name (pre-Windows 2000):

Active Directory Users and Computers - New Object Group

Continue reading → Workflow 2.0 Requires Display Names for AD Groups Used as Approver

● Categories: Dynamics, GP, Microsoft, Workflow ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

eConnect Incoming Service Won’t Start

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPeConnect is both a very useful tool for integrating data into Microsoft Dynamics GP, and also hugely frustrating. I assisted a client in creating a new test system recently and had some problems with eConnect. I installed it as normal, but the service didn’t start; when I tried to start the service manually, it started and immediately stopped without showing an error message.

I checked in the Windows Event Viewer for any errors and, again, there were none.

I’ve previously had issues with the eConnect service not starting and I figured it was worth a try.

The post linked above, has step by step screenshots, but the gist of what I tried is as follows:

  1. Make the eConnect service account an admin in Local Users and Groups.
  2. Start the service and note that it started correctly and continued to run.
  3. Stop the service
  4. Remove the eConnect Service from the Admins group.
  5. Start the service and again note that it started and continued to run.

The service has continued to run correctly since then.

● Categories: Dynamics, eConnect, GP, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

I’ve encountered this particular issue around the prerequisites so rarely, that I usually forget to mention it.

When installing the Web Services for Microsoft Dynamics GP there is a step where the SQL Server Connection Information is entered. This is the server where the Dynamics Security data will be stored.

You will receive the following message when clicking Next if the Windows user account you’re logged in as, is not a SQL Server sysadmin:

Invalid SQL Information - The current user must be a member of the sysadmin SQL role.

Invalid SQL Information

The current user must be a member of the sysadmin SQL role.

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite

● Categories: Dynamics, GP, Microsoft, Web Services ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

.NET 4.6 Installation Error When Installing Microsoft Dynamics GP 2016 R2 Prerequisites

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPOne of the prerequisites of Microsoft Dynamics GP 2016 R2 is .NET 4.6. However, occasionally when installing it, the Microsoft Dynamics GP 2016 Bootstrapper Setup will throw an error showing that the .NET Framework installation failed:

.NET installation error

Microsoft Dynamics GP 2016 Bootstrapper Setup

An error occurred while installing system components for Microsoft Dynamics GP 2016 Bootstrapper. Setup cannot continue until all system components have been installed.

The problem is that neither this error message nor the error log it directs you to contains information as to the cause of the error.

Continue reading → .NET 4.6 Installation Error When Installing Microsoft Dynamics GP 2016 R2 Prerequisites

● Categories: .NET Framework, Dynamics, GP, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Installing SQL Server Management Studio

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In previous versions of Microsoft SQL Server, SQL Server Management Studio (SSMS) was always part of the standard install, but it seems this has changed with SQL Server 2016.

Instead SSMS is now available as a separate download. I’d recommend downloading the GA rather than any release candidate which might be available:

Download SQL Server Management Studio (SSMS)

Continue reading → How To Install Microsoft SQL Server 2016: Installing SQL Server Management Studio

● Categories: Microsoft, SQL Server, SQL Server 2016, SSMS ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: SSIS Configuration For Named Instances

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In the last post, I installed SSIS, but if you are using a named Instance of SQL Server, there is a configuration step required.

To make the change, there is a file called MsDtsSrvr.ini which, for SQL Server 2016, is located in C:\Program Files\Microsoft SQL Server\130\DTS\Binn. The ServerName needs to be changed to include the full SQL Server Instance Name (as highlighted below):

MsDtsSrvr.ini file in Notepad

Once the full SQL Server Instance Name was added and the file saved, SSIS is ready to use.

Click to show/hide the How To Install Microsoft SQL Server 2016 Series Index

● Categories: Microsoft, SQL Server, SQL Server 2016, SSIS 2016 ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Installing SQL Server Integration Services

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

When I started the installation of the Analysis Cubes for Microsoft Dynamics GP as part of my ‘Hands On with GP 2016 R2 series, I knew I needed SQL Server Analysis Services (clue was in the name), but I didn’t initially realise that I was going to need SQL Server Integration Services (SSIS) although in retrospect it should have been obvious too.

The reason SSIS is needed, is that the Analysis Cubes in SSAS are populated by integration jobs from SSIS (scheduled using SQL Server Agent).

So I had to come back and install SSIS. You do this by launching the SQL Server setup utility and, under Installation click on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading → How To Install Microsoft SQL Server 2016: Installing SQL Server Integration Services

● Categories: Microsoft, SQL Server, SQL Server 2016, SSIS 2016 ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Installing SQL Server Analysis Services

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

I typically don’t install SQL Server Analysis Services (SSAS), but decided to this time as I was installing all of the Microsoft Dynamics GP additional products for my Hands On with Microsoft Dynamics GP 2016 R2 series.

To install SSAS, launch the SQL Server setup utility and click on Installation and then on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading → How To Install Microsoft SQL Server 2016: Installing SQL Server Analysis Services

● Categories: Dynamics, GP, Microsoft, SQL Server, SQL Server 2016, SSAS 2016 ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In the last post, I installed the SQL Server Database Engine and the Reporting Services, but I did not configure Reporting Services. I mentioned that I have had problems before when doing this, so always do it separately.

To configure SQL Server Reporting Services (SSRS), launch Reporting Services Configuration Manager from the Windows Start menu.

Select the Report Server Instance to connect to and click Connect:

Reporting Services Configuration Connection

Continue reading → How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services

● Categories: Dynamics, GP, Microsoft, SQL Server, SQL Server 2016, SSRS 2016 ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Installing SQL Server Database Engine

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In this post, I am going to step through the installation of the Microsoft SQL Server 2016 Database Engine. As most of my work is with Microsoft Dynamics GP, there will be a little focus on the installation required specifically for Dynamics GP, but the basic install is the same regardless of whether it is for Dynamics GP or not.

Launch the SQL Server setup utility (setup.exe), select Installation and click on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading → How To Install Microsoft SQL Server 2016: Installing SQL Server Database Engine

● Categories: Dynamics, GP, Microsoft, SQL Server, SQL Server 2016, SSRS 2016 ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●