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

Microsoft Dynamics GPThe 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 2013 SP2 Web Client Scale-Out Deployment: Deploying The Fabrikam Sample Company"

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Installing The Server

Microsoft Dynamics GPNow we have a client installed, we can use this to install the server. To do this run GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading "Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Installing The Server"

Microsoft Dynamics GP Utilities – Install Of Database Failed

Microsoft Dynamics GPI 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

Microsoft Dynamics GPThe 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 Install Microsoft Dynamics GP 2013 – How To Create A Company"

How To Deploy The Demo Company In Microsoft Dynamics GP 2010

Microsoft Dynamics GPIn 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 Deploy The Demo Company In Microsoft Dynamics GP 2010"

How To Create A Company In Microsoft Dynamics GP 2010

Microsoft Dynamics GPIn 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 "How To Create A Company In Microsoft Dynamics GP 2010"

Unknown Error Creating Demo Company

Microsoft Dynamics GPThis is another mea culpa post; I've been doing enough of them I'm thinking of giving them their own tag.

I was created a virtual machine with the Fabrikam, Inc. demo company in it. When GP Utilities was processing I got this error pop up;

Microsoft Dynamics GP Utilities - An unknown error occurred when initialising tyhe conversion.

Continue reading "Unknown Error Creating Demo Company"

Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2

Microsoft Dynamics GPI did a bit of searching and couldn't find a specific declaration of the upgrade path from Microsoft Dynamics GP 9 SP3 to Microsoft Dynamics GP 2010 R2.

After reading around and trying to work out the correct path, I decided the likely upgrade path would be GP 9 SP3 > GP 10 SP5 > GP 2010 R2, but I would try GP 9 SP3 > GP 2010 R2 and see if it would work (although I was extremely skeptical) as this would save some time on the upgrades if it was possible. Continue reading "Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2"

Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue

Microsoft Dynamics GPIt's always the small things which catch you out.

The recent test upgrade for a client I did between Microsoft Dynamics GP 10 SP5 and Microsoft Dynamics GP 2010 R2 hit a minor snag during the GP Utilities section of the upgrade which resulted in this error message;

Microsoft Dynamics GP 10 Utilities

Continue reading "Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue"

Microsoft Dynamics GP 2010 Utilities: BCP Utility Error

Microsoft Dynamics GPI have just returned from customer site where I did an upgrade of Microsoft Dynamics GP 10 to Microsoft Dynamics GP 2010 (I wish they'd called it GP 11 as the current nomenclature confuses customers) and got the error I often get when upgrading or installing GP on Windows 7 or Windows Server 2008 systems and have forgotten to do one of two very simple things. The explanation of the two things later, but first, the error message;

An error occurred while using the BCP utility--data was not correctly copied to the server. Please verify your ODBC settings and that BCP has been correctly installed. Microsoft Dynamics Utilities will now exit.

Continue reading "Microsoft Dynamics GP 2010 Utilities: BCP Utility Error"