Hands On With Microsoft Dynamics GP 2015 R2: Install System Database

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

The second post in this series, covers the installation of the System database. This is the database which holds the deployed companies and security configuration amongst oither items. To install the System database, run GP Utilities from the Start screen.

Despite what seems to be a regular argument I seem to have with Infrastructure people, you must log into GP Utilities using the sa account in order to be able to install the System database (no “ifs”, no “buts”; it must be sa):

Welcome to Microsoft Dynamics GP Utilities

Continue reading

Microsoft Dynamics GP 2015 R2 Launch Problem

Microsoft Dynamics GPDespite my assumptions about hotel Wi-Fi I have been able to download the Microsoft Dynamics GP 2015 R2 installation media. However, I have encountered an issue when trying to launch the client following the install.

I wondered if someone else would be able to verify my findings?

I installed in on my laptop which already has the following installed;

  1. Microsoft Dynamics GP 2010 SP3
  2. Microsoft Dynamics GP 2013 SP2
  3. Microsoft Dynamics GP 2013 R2
  4. Microsoft Dynamics GP 2015

GP Utilities appears to run OK, but when I try to launch the desktop client, it tells me I need to launch GP Utilities and ends up in a perpetual loop of me running GP Utilities then the desktop client and so on.

When I installed the software it did ask if I wanted to update the 2015 instance which I declined and installed a named instance of 2015 R2. I am wondering if this is because I have other versions of the client installed?

Hands On With Microsoft Dynamics GP 2015 RTM: Create A New Company

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts on how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here.

In this post, I’m going to cover how to create a company in Dynamics GP 2015. To create a company, launch GP Utilities and log in with a user account which has permissions to create a database (for ease I typically use the sa account, but any account with the relevant permissions can be used):

Welcome to Microsoft Dynamcis GP Utilities

Continue reading

Hands On With Microsoft Dynamics GP 2015 RTM: Sample Company Deployment

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts o how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here. I am assuming you already have your server built with Windows and SQL Server for this series.

In the last post I deployed the system database; in this one I’m going to take a look at deploying the sample company. While this isn’t something generally done with a new system, I am in the process of building a new demo/test environment.

We’ll pick up where the previous post left off on the Additional Tasks step of GP Utilities. If you had closed GP Utilities log back in and progress through to this step and in the combo box, in the middle of the screen, make sure it is set to Add sample company data and click Process:

Additional Tasks

Continue reading

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Deploying The Fabrikam Sample Company

The Fabrikam sample company is deployed via GP Utilities. Log into it using the sa account and progress through to the Additional Tasks. In the drop down list select Add sample company data and click :

Additional Tasks

Continue reading

Microsoft Dynamics GP Utilities – Install Of Database Failed

I was asked to create a new company for a client recently, who is still running Microsoft Dynamics GP 9, which should have been an easy task. However, when I tried to run GP Utilities to create the company I received an error:

Microsoft Dynamics GP Utilities - Install of database GPTV failed! Microsoft Dynamics GP Utilities will now shut downMicrosoft Dynamics GP Utilities – Install of database GPTV failed! Microsoft Dynamics GP Utilities will now shut down

I did a bit of exploring and testing of the system, but couldn’t identify the problem. I then tried to search online and did come across a Microsoft Knowledge Base article but it was of no help. I finally decided that the problem might be the client installation I was using.

As mentioned, this particular client is still using Microsoft Dynamics GP 9 which had a separate server components install (they are in the middle of an upgrade project to bring them to the latest version) which complicated things a little as I couldn’t just use any other client.

Instead, I made a did a backup of their DYNAMICS system database and loaded it onto a VM with SQL 2000 and GP 9 SP3 already installed. I was able to use the GP Utilities in the VM to successfully create the company.

That done, I backed up the system and company database and restored them to the clients live SQL Server before anyone started work in the morning. This approach is a little roundabout, but it was a little easier than reinstalling the client on the server and meant I didn’t risk disrupting anything.

How To Install Microsoft Dynamics GP 2013 – How To Create A Company

The Microsoft Dynamics GP sample company, which I showed how to install in the last post, is good for doing a demo or for testing, but in the real world most sites will never deploy the sample company. Instead their efforts will be focused on creating a company to host their own data, which is what we’re going to take a look at in this post.

New companies are created using GP Utilities (Windows Start menu >> All Programs >> Microsoft Dynamics >> GP 2013 >> GP Utilities) and login using the sa password;

Welcome to Microsoft Dynamics GP Utilities

Continue reading

How To Deploy The Demo Company In Microsoft Dynamics GP 2010

In the last couple of posts, I showed how to configure the server of Microsoft Dynamics GP by creating the System database and how to create a new company. In this post I’m going to run through deploying the Fabrikam, Inc. demo company.

To create the company, open GP Utilities (Windows Start menu >> All Programs >> Microsoft Dynamics >> GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);

Welcome to Microsoft Dynamics GP Utilities

Continue reading

How To Create A Company In Microsoft Dynamics GP 2010

In the last post, I showed how to configure the server of Microsoft Dynamics GP by creating the System database. In this post I’m going to run through the company creation process.

To create the company, open GP Utilities (Windows Start menu >> All Programs >> Microsoft Dynamics >> GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);

Welcome to Microsoft Dynamics GP Utilities

Continue reading