80226 Installation and Configuration in Microsoft Dynamics GP 2010

Displaying courses for United States [Change]
This course provides material for:
Microsoft Exam code: MB3-861


Students will learn the basics of Microsoft Dynamics GP installation and setup, in addition to advanced topics such as optimization and troubleshooting.


After completing this course, students will be able to:
  • Identify the requirements and prerequisites of Microsoft Dynamics GP, including those related to Terminal Services and virtualization.
  • Install Microsoft SQL Server 2008 and Microsoft SQL Server 2008 Express with recommended settings as they relate to Microsoft Dynamics GP.
  • Use Microsoft Dynamics GP Utilities to initialize the DYNAMICS database using the basic and advanced options.
  • Identify account framework parameters and other system settings.
  • Perform additional tasks in Microsoft Dynamics GP Utilities, including creating additional companies.
  • Install Microsoft Dynamics GP on a client workstation.
  • Create and use an installation package for client workstations.
  • Create automatic updates for customization and service pack deployment.
  • Identify components and files installed by Microsoft Dynamics GP, including settings in the dex.ini and Dynamics.set files.
  • Complete system setup, including registration and system preferences.
  • Create users and define access to companies.
  • Use Security Tasks, Roles, and Alternate/Modified Forms and Reports to define security.
  • Maintain Microsoft Dynamics GP databases.
  • Use the Microsoft Dynamics GP Database Maintenance Utility to recreate database objects.
  • Use the Microsoft SQL Server Maintenance Plan Wizard.
  • Define the settings for optimizing Microsoft Dynamics GP performance.
  • Analyze performance by monitoring SQL Server with System Monitor.
  • Use SQL Profiler and the dexsql.log to troubleshoot technical issues.
  • Set up and configure Process Server.
  • Explain the purpose of Report Writer.
  • Deploy and configure Microsoft SQL Server 2008 Reporting Services reports with Microsoft Dynamics GP.
  • Deploy and manage Microsoft Excel Reports for Microsoft Dynamics GP.
  • Configure Microsoft Office Word Templates for Microsoft Dynamics GP.
  • Configure e-mail distribution of reports.
  • Configure and use Report Scheduler.


Microsoft Dynamics GP Installation and Configuration training is recommended for people who plan to install, implement, configure, consult, or support Microsoft Dynamics GP. The class is intended for administrators, implementers, developers, and consultants who need to understand the technical aspects of Microsoft Dynamics GP. The course is not intended for non-technical staff.


Microsoft Dynamics GP System Requirements and SQL Server Installation

  • Microsoft Dynamics GP SQL Server Requirements
  • Hardware Recommendations and Configurations
  • Terminal Server and Virtualization Requirements
  • Optimize the System for Microsoft SQL Server
  • Install Microsoft SQL Server 2008
  • Microsoft SQL Server 2008 Express System Requirements, Installation, and Configuration

Data Server Installation and Utilities

  • Initial Installation
  • Microsoft Dynamics GP Utilities basic and advanced installation options
  • Dynamics Database Initialization
  • Account Framework Setup
  • Set System Options
  • Sample Company Initialization
  • Create Additional Companies
  • Troubleshoot Errors
  • Lab : Install Microsoft Dynamics GP
  • Lab : Run Microsoft Dynamics GP Utilities

Client Installation, Components, and Maintenance

  • Client Requirements and Installation
  • Adding or Removing Additional Features
  • Create and Use a Client Installation Package
  • Apply Service Packs and Updates Using Automatic Updates
  • Installation Components and Files
  • Identity Columns
  • Stored Procedures
  • Lab : Create client installation package

System Manager

  • System Setup
  • User Setup and Access
  • Security Tasks
  • Security Roles
  • Alternate/Modified Forms and Reports
  • User Activity and Preferences
  • Company Setup
  • Lab : System Manager (User Setup and Security)

Post Installation Administration

  • Database Options
  • Database Backup and Restore Procedures
  • Microsoft Dynamics GP-SQL Maintenance
  • Microsoft Dynamics GP Database Maintenance Utility
  • SQL Database Maintenance (DBCC)
  • Use the Microsoft SQL Server Maintenance Plan Wizard
  • Microsoft Dynamics GP Maintenance Procedures
  • Lab : Back up database
  • Lab : Drop and create auto procedure

Optimize Performance and Troubleshooting

  • Windows Server Considerations
  • SQL Server Configuration
  • Optimize an SQL Relational Database
  • Analyze Network and SQL Server Performance
  • Optimization Summary
  • Troubleshooting - Identify the Issue
  • Troubleshooting - Types of Issues and Resolution Sources
  • Batch Recovery Process
  • Lab : SQL Memory Options
  • Lab : Using SQL Profiler
  • Lab : Create dexsql.log

Process Server

  • Overview
  • System Requirements
  • Set Up Process Server
  • Designate the Output Report Location
  • Process Monitor
  • Process Server Log


  • Report Writer Overview
  • SQL Server Reporting Services
  • SQL Server Reporting Services Wizard
  • Microsoft Report Server Project Wizard
  • Microsoft Office Excel Reports
  • Configure and Deploy Data Connections and Excel Reports
  • Microsoft Word Templates
  • Distribute Reports by E-Mail
  • Report Scheduler
  • Lab : Create a Modified Report
  • Lab : Create a Custom Report
  • Lab : Deploy Excel Reports
  • Lab : Schedule a report

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 3 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Microsoft Dynamics GP
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.
Microsoft Office
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.
Microsoft SQL Server
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.
Windows Server
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.