MOC 80226 - Installation and Configuration in Microsoft Dynamics GP 2010

Delivery Options

• Live Online Training - Public Class (3 days): $1,425.00

» Free Demo

» Watch Presentation

» More Info

» Contact Education Consultant

• Customized Onsite Training (3 days): Request a Proposal

Upcoming Live eLearning Classes

There are currently no upcoming Live eLearning classes. Please contact us if you would like us to schedule a class.

Class Description

Class Overview

Class Goals

• Learn to install Microsoft SQL Server 2008 and Microsoft SQL Server 2008 Express with recommended settings as they relate to Microsoft Dynamics GP.
• Learn to use Microsoft Dynamics GP Utilities to initialize the DYNAMICS database using the basic and advanced options.
• Learn to identify Dynamics GP 2010 account framework parameters and other system settings.
• Learn to perform additional tasks in Microsoft Dynamics GP Utilities, including creating additional companies.
• Learn to install Microsoft Dynamics GP 2010 on a client workstation.
• Learn to identify components and files installed by Microsoft Dynamics GP 2010, including settings in the dex.ini and Dynamics.set files.
• Learn to use SQL Profiler and the dexsql.log to troubleshoot technical issues in Microsoft Dynamics GP 2010.

Class Outline

1. Microsoft Dynamics GP System Requirements and SQL Server Installation
   1. Microsoft Dynamics GP SQL Server Requirements
   2. Hardware Recommendations and Configurations
   3. Terminal Server and Virtualization Requirements
   4. Optimize the System for Microsoft SQL Server
   5. Install Microsoft SQL Server 2008
   6. Microsoft SQL Server 2008 Express System Requirements, Installation, and Configuration
2. Data Server Installation and Utilities
   1. Initial Installation
   2. Microsoft Dynamics GP Utilities basic and advanced installation options
   3. Dynamics Database Initialization
   4. Account Framework Setup
   5. Set System Options
   6. Sample Company Initialization
   7. Create Additional Companies
   8. Troubleshoot Errors
   9. Lab: Install Microsoft Dynamics GP
   10. Lab : Run Microsoft Dynamics GP Utilities
3. Client Installation, Components, and Maintenance
   1. Client Requirements and Installation
   2. Adding or Removing Additional Features
   3. Create and Use a Client Installation Package
   4. Apply Service Packs and Updates Using Automatic Updates
   5. Installation Components and Files
   6. Identity Columns
   7. Stored Procedures
   8. Lab: Create client installation package
4. System Manager
   1. System Setup
   2. User Setup and Access
   3. Security Tasks
   4. Security Roles
   5. Alternate/Modified Forms and Reports
   6. User Activity and Preferences
   7. Company Setup
   8. Lab: System Manager (User Setup and Security)
5. Post Installation Administration
   1. Database Options
   2. Database Backup and Restore Procedures
   3. Microsoft Dynamics GP-SQL Maintenance
   4. Microsoft Dynamics GP Database Maintenance Utility
   5. SQL Database Maintenance (DBCC)
   6. Use the Microsoft SQL Server Maintenance Plan Wizard
   7. Microsoft Dynamics GP Maintenance Procedures
   8. Lab: Back up databaseLab : Drop and create auto procedure
6. Optimize Performance and Troubleshooting
   1. Windows Server Considerations
   2. SQL Server Configuration
   3. Optimize an SQL Relational Database
   4. Analyze Network and SQL Server Performance
   5. Optimization Summary
   6. Troubleshooting - Identify the Issue
   7. Troubleshooting - Types of Issues and Resolution Sources
   8. Batch Recovery Process
   9. Lab: SQL Memory Options
   10. Lab: Using SQL Profiler
   11. Lab: Create dexsql.log
7. Process Server
   1. Overview
   2. System Requirements
   3. Set Up Process Server
   4. Designate the Output Report Location
   5. Process Monitor
   6. Process Server Log
8. Reporting
   1. Report Writer Overview
   2. SQL Server Reporting Services
   3. SQL Server Reporting Services Wizard
   4. Microsoft Report Server Project Wizard
   5. Microsoft Office Excel Reports
   6. Configure and Deploy Data Connections and Excel Reports
   7. Microsoft Word Templates
   8. Distribute Reports by E-Mail
   9. Report Scheduler
   10. Lab: Create a Modified Report
   11. Lab: Create a Custom Report
   12. Lab: Deploy Excel Reports
   13. Lab: Schedule a report
9. Appendix A: Job Aids
   1. Microsoft Dynamics GP Checklist
   2. Microsoft SQL Server Installation Checklist
   3. System Setup Checklist
   4. Process Server Checklist
   5. Reports
10. Appendix B: Additional Components
    1. Installation Media Content
    2. Microsoft Dynamics GP Features

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following areas is required:

• Knowledge of Microsoft Windows Server 2008, Microsoft Windows Server 2003, Microsoft Windows XP, or Microsoft Windows Vista
• Knowledge of Microsoft SQL Server 2008 or Microsoft SQL Server 2005

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Instructor-led Online course technical requirements and setup instructions.
• WebEx system requirements for Instructor-led Online delivery option.
• Onsite course technical requirements and setup instructions.
• Hosted eLearning course technical requirements and setup instructions.
• Hosted eLearning course frequently asked questions.

Associated Certifications

• Microsoft Dynamics GP 2010 Installation & Configuration