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

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.

In this fourth post, I’m going to cover the creation of a new company; in this case I am going to create a company for Perfect Image Ltd. To create a new company, launch GP Utilities from the Home screen by right clicking and doing Run as Administrator. Log in using the sa or DYNSA account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading

Hands On With Microsoft Dynamics GP 2015 R2: Deploy The Sample Company

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 third post, covers the deployment of the Fabrikam, Inc. sample company. Launch GP Utilities from the Home screen by right clicking and doing Run as Administrator. Log in using the sa or DYNSA account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading

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

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

Change SQL Server From Windows Authentication To Mixed Mode

Microsoft Dynamics GPA while ago I was setting up SQL Server for a test system, I obviously wasn’t paying enough attention because when I tried to launch Microsoft Dynamics GP Utilities I received the below error:

Microsoft Dynamics GP Utilities: This login failed. Attempt to log in again or contact your system administratorMicrosoft Dynamics GP Utilities: This login failed. Attempt to log in again or contact your system administrator

Continue reading

Installing Microsoft Dynamics GP 2013 R2: Deploying The System Database

Microsoft Dynamics GP 2013 R2 is now available. And despite note really having the time to do so at the moment, I can’t stop myself from installing it (and as I always do blogging about it as I go).

In this series of posts I am going to do install a stand-alone instance of Microsoft Dynamics GP 2013 R2; the index for this series is here.

With the client software installed we can now deploy the system database. To do this launch GP Utilities from the Windows Start screen and log in using the sa or DYNSA user:

Welcome to Microsoft Dynamics GP Utilities

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