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

The first page of GP Utilities is just a welcome blurb explaining that GP Utilities is used to set up or upgrade Microsoft Dynamics GP;

Welcome to Microsoft Dynamics GP Utilities

GP Utilities will check that the system database version matches the version of GP Utilities;

Upgrade Microsoft Dynamics GP

If there are companies already in the system they will also be checked. If the companies match the version or if there is no companies currently created, GP Utilities will progress to the Additional Tasks page where you can select to add sample company data in the combo. Once you’ve selected this option, click the Process button;

Additional Tasks

Accept or alter the default entries for the location of the data and log files of the demo company database;

Database Setup

Choose whether to create the two sample users, LessonUser1 and LessonUser2. If you choose to create them you will need to enter and confirm a password.

I never create these users as I prefer to create individual users for testing purposes;

Create Sample Users

Check the creation options and confirm the demo company should be created;


Choose whether the Microsoft SQL Server Reporting Services reports and the Excel reports should be deployed for the demo company;

Business Integlligence Reports Setup

If you selected to deploy the SQL Server Reporting Services Reports you’ll be prompted to pick the Report Server Mode and the report server and manager URLs. These will be defaulted in from the settings defined when the System was configured but can be changed as required.

Before deploying the SQL Reporting Services reports make sure the maxRequestLength has been corrected (as described mid-way down the linked post);

SQL Server Reporting Services Reports Setup

Enter the location and Network Share to be used for deploying the Excel Reports. The share location should be entered using a UNC path to a shared network location rather than a mapped drive;

Excel Reports Setup

Confirm the selections are accurate;

Verify SQL Server

The report deployment will take a short time to run through but will display progress bars to show progress;

Business Intelligence Deployment Progress

Choose whether to set up the company later, to set it up using the configuration wizard or to migrate existing data using the migration wizard.

After selecting the previous option, I was returned to the Additional Tasks window where you can create a company or alternatively click Launch Microsoft Dynamics GP to start GP;

Additional Tasks

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

3 thoughts on “How To Deploy The Demo Company In Microsoft Dynamics GP 2010

  1. Pingback: Comment
  2. Pingback: Comment
  3. Pingback: Comment

Leave a Reply

Your email address will not be published. Required fields are marked *