Installation & Configuration

Working Knowledge of Microsoft Windows 2003, Microsoft Windows XP, or Microsoft Windows Vista, and Microsoft SQL Server 2000 or Microsoft SQL Server 2005.

Training Type: Classroom
Duration: 20hrs


Sub Topic


Installation & Configuration

  • Microsoft Dynamics GP System Requirements and SQL Server Installation
  • Data Server Installation and Utilities
  • Client Installation, Components, and Maintenance
  • System Manager
  • Post Installation Administration
  • Optimize Performance and Troubleshooting
  • Process Server
  • Reporting
  • Appendix: Job Aids
  • Appendix: Overview of TCP/IP
  • Appendix: Additional Components

20 Hours

Module 1: Microsoft Dynamics GP System Requirements and SQL Server Installation

This chapter looks at the key issues about how to install Microsoft SQL Server 2005. An installation is not performed in class but important installation decisions are discussed. This chapter also discusses installing SQL Server 2005 Express for use with Microsoft Dynamics GP. In addition, terminal server requirements and a few common command line tools are reviewed.

Module 2: Data Server Installation and Utilities

This chapter examines the process of installing Microsoft Dynamics GP in a client/server environment. This includes discussing the installation wizard and looking at the various options to select during the installation. This chapter also examines how to setup Microsoft Dynamics GP databases, account framework, additional sorting options, and additional tasks using Microsoft Dynamics GP Utilities. The chapter focuses on the steps performed immediately after installing the Microsoft Dynamics GP program files.

Module 3: Client Installation, Components, and Maintenance

This chapter provides guidance when installing Microsoft Dynamics GP on a client workstation, including adding and removing features and components after the initial installation. Hardware and software requirements are examined as well as the ability to install the client using a client installation package.
This chapter also identifies how to automate the process of applying updates such as service packs and customizations to the Microsoft Dynamics GP application using the automatic updates feature. Finally, this chapter discusses the files installed during the Microsoft Dynamics GP installation and looks at how identity columns and stored procedures are used in Microsoft Dynamics GP.

Module 4: System Manager

This chapter examines the System manager components of Microsoft Dynamics GP. Specifically, the creation of users, security tasks, security roles, and specifying other system options.

Module 5: Post Installation Administration

This chapter examines the database options to define for the Microsoft Dynamics GP databases. It also discusses maintenance of Microsoft Dynamics GP databases and identifies database backup and restore procedures. The creation of a database maintenance plan is also covered, together with the recommended maintenance tasks for Microsoft Dynamics GP. Other maintenance methods, including SQL maintenance and data recovery tools are discussed.

Module 6: Optimize Performance and Troubleshooting

This chapter discusses how to optimize the Windows Server system. Specifically, it looks at settings for memory, CPU, network, and the disk subsystem through system monitor. This chapter also discusses the methodology around troubleshooting Microsoft Dynamics GP. Several tools used in troubleshooting including SQL Profiler and a dexsql.log are examined, and the batch recovery process is discussed.

Module 7: 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, learn how to define tasks to run remotely and define which servers will run remote tasks.

Module 8: Reporting

This chapter provides an overview of Report Writer, SQL Reporting Services, and the FRx application. It does not delve into the inner workings of extracting financial information in FRx. Included in this chapter is configuring databases for use with FRx and defining the folder structure for reports. This chapter also discusses how to set up the Report Scheduler option.

Module 9: Appendix: Job Aids

This appendix provides checklists, commonly used reports, and a Microsoft SQL script to remove tables.

Module 10: Appendix: Overview of TCP/IP

This appendix includes an overview of TCP/IP

Module 11: Appendix: Additional Components

This appendix contains information about the additional components available together with the Microsoft Dynamics GP installation.

Our Customers

Always and forever at your Service