Installation & Configuration in Microsoft Dynamics GP 9.0

Code: 8505
Course duration: 3 days

8505: Installation & Configuration in Microsoft Dynamics GP 9.0 (3 Days)

About this Course

The three-day Microsoft Dynamics GP Installation and Configuration course develops your understanding of technologies and techniques that are necessary to successfully install Microsoft Dynamics GP. By covering the basics of installation, setup, and advanced topics such as optimization and troubleshooting, this course builds your confidence and minimizes the installation time for your customers. Microsoft SQL Server is discussed as it specifically applies to the optimization of Microsoft Dynamics GP. The course covers the installation of Microsoft Dynamics GP and the installation of the related products that are listed in the agenda. This course does not discuss the setup and use of the application because these topics are covered by other classes that are offered by Microsoft Training.

Audience Profile

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 targeted toward 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.

Prerequisites

Before students attend this course, they must have:

  • A working knowledge of Microsoft Windows 2000, Windows Server 2003, or Windows XP, and SQL Server 2000.

At Course Completion

After completing this this course, students should be able to do the following:

  • Identify the architecture of Microsoft Dynamics GP
  • Identify the hardware requirements for Microsoft SQL Server in a Microsoft Dynamics GP environment
  • Install the MSDE version of Microsoft SQL Server as it relates to Microsoft Dynamics GP
  • Create a Data Source Name (DSN) for Microsoft Dynamics GP
  • Identify the correct settings for an ODBC source for Microsoft Dynamics GP
  • Install Microsoft Dynamics GP in a client and server environment
  • Identify account framework parameters
  • Create additional companies
  • Install Microsoft Dynamics GP on a client workstation
  • Identify the different hardware and software requirements for a Microsoft Dynamics GP client
  • Identify how to create an installation package for a client installation
  • Identify service packs and automatic updates
  • Identify the relationship of the Microsoft Dynamics GP series
  • Create users and grant user access in Microsoft Dynamics GP
  • Register Microsoft Dynamics GP
  • Set up security and classes in Microsoft Dynamics GP
  • Track user activity in Microsoft Dynamics GP
  • Identify components and files that were installed by Microsoft Dynamics GP
  • Identify the features of Microsoft Dynamics GP
  • Configure database options
  • Set up a database maintenance plan
  • Perform SQL maintenance
  • Define the settings for optimizing Microsoft Dynamics GP performance
  • Identify System Monitor counters that are used in optimizing performance
  • Setup and configure Process Server
  • Identify settings of Process Server
  • Install FRx for Microsoft Dynamics GP
  • Identify the characteristics of Microsoft FRx
  • Define the characteristics of Report Scheduler
  • Configure Report Scheduler
  • Identify the characteristics of Microsoft SQL Server Profiler
  • Create a dexsql.log file
  • Troubleshoot Microsoft Dynamics GP

Course Outline

Module 1: Microsoft SQL Server Install


This chapter examines the key issues with installing Microsoft SQL Server. An installation is not performed in class, but important installation decisions are discussed.

Lessons

  • Overview of Microsoft SQL installation
  • System requirements for Microsoft Dynamics GP on Microsoft SQL Server
  • Installation of Microsoft SQL Server 2000

After completing this chapter, students will be able to:

  • Install Microsoft SQL Server
  • Identify hardware requirements for Microsoft SQL Server for use with Microsoft Dynamics GP

Module 2: Microsoft SQL Server Install MSDE


This chapter discusses how to install the MSDE version of SQL for use with Microsoft Dynamics GP. In addition, several common command line tools are reviewed.

Lessons

  • MSDE System Requirements
  • MSDE Installation
  • MSDE Configuration Tools

After completing this chapter, students will be able to:

  • Install the MSDE version of Microsoft SQL Server for use with Microsoft Dynamics GP

Module 3: ODBC Setup


Microsoft Dynamics GP requires an ODBC connection to the Microsoft SQL Server to access data. This chapter focuses on the specific settings for creating a data source name.

Lessons

  • Setting up ODBC

After completing this chapter, students will be able to:

  • Create a Data Source Name (DSN) for Microsoft Dynamics GP
  • Identify the correct settings for an ODBC source for Microsoft Dynamics GP

Module 4: Microsoft Dynamics GP Data Server Installation


This chapter examines the process of installing Microsoft Dynamics GP on Microsoft SQL Server. This includes examining each installation screen and looking at the various options to select during the installation.

Lessons

  • Server Installation

After completing this chapter, students will be able to:

  • Install Microsoft Dynamics GP in a Client/Server environment

Module 5: Microsoft Dynamics GP Utilities


This chapter examines how to set up your Microsoft Dynamics GP databases, account framework, additional sorting options, and how to create a client template. The chapter focuses on the steps that you perform immediately after you install the Microsoft Dynamics GP program files.

Lessons

  • Microsoft Dynamics GP Utilities
  • Dynamics database initialization
  • Account framework setup
  • Setting system options
  • Additional tasks
  • Initializing the sample company
  • Creating additional companies
  • Register Microsoft Dynamics GP
  • Removing SOP and invoicing message
  • Starting Dynamics GP from the Utilities window
  • Troubleshooting

After completing this chapter, students will be able to:

  • Identify account framework parameters
  • Initialize the sample company
  • Create additional companies

Module 6: Microsoft Dynamics GP Client Installation


This chapter guides you through the various processes of how to install Microsoft Dynamics GP on a client workstation. Hardware and software requirements are examined as well as the ability to install the client from a template.

Lessons

  • Microsoft Dynamics GP client requirements
  • Installing the application on subsequent client workstations
  • Microsoft Dynamics GP client installation package

After completing this chapter, students will be able to:

  • Install Microsoft Dynamics GP on a client workstation
  • Identify the hardware and software requirements for a client workstation

Module 7: Microsoft Dynamics GP Service Packs and Updates


This chapter identifies how to automate the process of applying updates to the Microsoft Dynamics GP application. Specifically, how to apply service packs and create automatic updates so all client computers receive the same updates.

Lessons

  • Service packs
  • Automatic updates

After completing this chapter, students will be able to:

  • Identify where to go to find the latest available service pack
  • Identify the benefits of using automatic updates

Module 8: Microsoft Dynamics GP System Manager


This chapter examines the System Manager components of Microsoft Dynamics GP. Specifically, it examines how to create users, security, classes, and companies. In addition, this chapter examines several standard reports that are included with Microsoft Dynamics GP.

Lessons

  • The Microsoft Dynamics GP series
  • System and company setup
  • System password setup
  • User classes
  • User setup
  • User access
  • Advanced Security Setup
  • Security setup
  • User activity
  • User preferences
  • Registration
  • System reports
  • Company setup procedures
  • Create company
  • Company information
  • Internet information
  • Company reports

Lab : Test your skills for creating users, classes, and company access


After completing this chapter, students will be able to:

  • Identify the relationship of the Microsoft Dynamics GP series
  • Create users and grant user access in Microsoft Dynamics GP
  • Setup security and classes in Microsoft Dynamics GP
  • Track user activity in Microsoft Dynamics GP
  • Register Microsoft Dynamics GP
  • Setup company information in Microsoft Dynamics GP

Module 9: Microsoft Dynamics GP Components


This chapter discusses the files that are installed during the installation of Microsoft Dynamics GP.

Lessons

  • Installation components and files
  • Where to store dictionaries

After completing this chapter, students will be able to:

  • Identify components and files that are installed by Microsoft Dynamics GP

Module 10: Microsoft Dynamics GP Features


This chapter describes a batch recovery process, and examines how identity columns and stored procedures are used in Microsoft Dynamics GP.

Lessons

  • Batch recovery process
  • Identity columns
  • Stored procedures

Lab : Test your skills working with Query Analyzer, and creating logon accounts

After completing this chapter, students will be able to:

  • Identify the features of Microsoft Dynamics GP

Module 11: Post Installation Administration


This chapter examines the database options that you need to set for your Microsoft Dynamics GP databases. It also discusses maintenance of Microsoft Dynamics GP databases. Additionally, it identifies database backup procedures. To complete the chapter, you will set up a database maintenance plan.

Lessons

  • Database options
  • Database backup procedures
  • Microsoft Dynamics GP SQL maintenance
  • SQL database maintenance
  • Using the Database Maintenance Wizard
  • Microsoft Dynamics GP data recovery procedures
  • Backup procedures within Microsoft Dynamics GP

After completing this chapter, students will be able to:

  • Configure database options
  • Set up a database maintenance plan
  • Perform SQL maintenance

Module 12: Optimizing Performance


This chapter discusses how to optimize your Windows Server system. Specifically, it examines settings for memory, CPU, network, and the disk subsystem through System Monitor.

Lessons

  • Windows Server operating system configuration
  • Windows Server operating system bottleneck analysis
  • Strategies for testing and tuning servers
  • SQL Server configuration
  • Methods of optimizing a SQL relation database
  • Analyzing less than optimal performance
  • Monitoring SQL Server with System Monitor
  • Optimization summary

After completing this chapter, students will be able to:

  • Define the settings for optimizing Microsoft Dynamics GP performance
  • Identify System Monitor counters that are used in optimizing performance

Module 13: Process Server


This chapter covers the basics of setting up Process Server. Terms are defined as well as the components of Process Server. During the chapter, you define tasks that you can run remotely, and you learn how to define which servers will run remote tasks. As a member of a team, you create an environment to process Checklinks remotely.

Lessons

  • Overview of Process Server
  • The DPS and DPM environment
  • Process Server setup
  • Designating the output report location
  • Process monitor
  • Process Server inquiry
  • Process Server reporting
  • Review of setup and execution

Lab : Using a partner in class, setup Process Server to remotely process Checklinks on other's computers


After completing this chapter, students will be able to:

  • Setup and configure Process Server
  • Identify settings of Process Server

Module 14: Microsoft FRx Installation


This chapter examines how to install the FRx application. However, it does not delve into the inner workings of extracting financial information. Included in this chapter is information about how to configure databases for use with FRx and how to define the folder structure for reports.

Lessons

  • Installation considerations
  • Pre-install: running SQL scripts for FRx
  • Create a shared folder on server
  • Running SQL Scripts for FRx
  • Installing FRx on the first workstation
  • Changing data paths and FRx registration
  • Setting up company information
  • Adding additional FRx workstations
  • FRx troubleshooting techniques and tips

After completing this chapter, students will be able to:

  • Install FRx for Microsoft Dynamics GP
  • Identify the characteristics of FRx

Module 15: Report Scheduler


This chapter discusses how to set up the Report Scheduler option.

Lessons

  • Report Scheduler

After completing this chapter, students will be able to:

  • Define the characteristics of Report Scheduler
  • Configure Report Scheduler

Module 16: Troubleshooting


This chapter discusses the method for troubleshooting Microsoft Dynamics GP. Then, you will examine several tools that are used in troubleshooting, and you will troubleshoot ten different scenarios.

Lessons

  • Identifying the problem and finding its source
  • Tools and sources
  • Problem solving using SQL Server Profiler
  • Problem solving using the dexsql.log file
  • Troubleshooting scenarios

Lab : Troubleshooting Microsoft Dynamics GP


After completing this chapter, students will be able to:

  • Identify the characteristics of Microsoft SQL Server Profiler
  • Create a dexsql.log file
  • Troubleshoot Microsoft Dynamics GP

Guaranteed to Run

2018-03-20 09:00 to 2018-03-23 17:00
Palm Beach County Florida (Instructor-Led)
2018-03-19 09:00 to 2018-03-23 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2018-03-01 09:00 to 2018-03-02 17:00
Palm Beach County Florida (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review