System Requirements for Microsoft Dynamics GP

=======================

Overview

This page lists the system requirements for Microsoft Dynamics GP 2018 and Microsoft Dynamics GP.

This document contains the minimum client hardware requirements, server recommendations and Terminal Server minimum hardware requirements supported by the Microsoft Dynamics GP Technical Support Team. The following server recommendations are not minimum server requirements. The requirements and recommendations are based on experience with many different installations. Users may need to increase these requirements due to environmental factors to achieve individual performance expectations.

Review each Customer Profile below to determine what profile best fits the user count, modules used and transaction volume for your environment. Use that Customer Profile as a recommendation for your server hardware implementation.

Client Requirements

This table lists client requirements

Item Requirements
32-bit x64
Operating System Microsoft Windows 10
Professional Edition
Microsoft Windows 10
Enterprise Edition
Microsoft Windows 8 & 8.1
Professional Edition
Microsoft Windows 8 & 8.1
Ultimate Edition
Microsoft Windows 8 & 8.1
Enterprise Edition
Microsoft Windows 7
Professional Edition
Microsoft Windows 7
Ultimate Edition
Microsoft Windows 7
Enterprise Edition
Microsoft Windows 10
Professional Edition
Microsoft Windows 10
Enterprise Edition
Microsoft Windows 8 & 8.1
Professional Edition
Microsoft Windows 8 & 8.1
Ultimate Edition
Microsoft Windows 8 & 8.1
Enterprise Edition
Microsoft Windows 7
Professional Edition
Microsoft Windows 7
Ultimate Edition
Microsoft Windows 7
Enterprise Edition
Processor 1 Dual Core or 1 Single Core Processor 2.6 GHz or higher 1 Dual Core or 1 Single Core Processor 2.6 GHz or higher
Available Hard Disk Space 2GB or more on the system root 2GB or more on the system root
Minimum Available RAM 2GB or more 2GB or more
Netowrk Card 1 GB Ethernet
Microsoft Office
32-bit & x64
Microsoft Office 2013 32bit & x64
Microsoft Office 2016 32bit &x64

NOTES:
1. If using Office x64, the server type in System Preferences
(Microsoft Dynamics GP>Tools>System>Setup>System
Preferences) must be set to Exchang.
2. Before you can send documents as DOCX, PDF, or XPS attachments,
the Word template for the document must be enabled
in the Template Configuration Manager window.
3. If using Office 32bit, the server type in System Preferences
caneither be MAPI or Exchange
4. Microsoft Dynamics GP 18.3 and later releases only supports Exchange 2013 or later.
Internet Explorer
32-bit & x64
Internet Explorer 11.0 - Desktop Mode Only
Edge
ODBC Driver
32-bit & x64
SQL Native Client 11.0
SQL Native Client 10.0

NOTE: A 32bit ODB DSN is required for Microsoft Dynamics GP 2016
Adobe Adobe X
Virtual Environments Supported (Optional) Hardware Virtualization
Windows Server 2016 Hyper-V
Windows Server 2012 Hyper-V
Windows Server 2012 R2 Hyper-V
Windows Server 2008 R2 Hyper-V
Windows Server 2008 Hyper-V

Software Virtualization
Microsoft Application Virtualization (App-V) 5.0

For additional Virtual Technology Support, review the Virtualization Support Policy Wizard. Choose Products to see if your Virtual Technology is listed.

NOTES

  1. A 32-bit ODBC DSN is required for Microsoft Dynamics GP on a 32-bit and x64 machine. Refer to Article 870416 for the steps to setup a 32-bit ODBC DSN on an x64 machine.

  2. Visual Basic for Applications (VBA) is not supported on Windows Server 2019, see BLOG for details.

  3. When you deploy a system in a virtual environment, make sure that you have
    sufficient hard disk space to avoid performance problems. Each computer that you deploy in a virtual environment should meet or exceed the random access memory (RAM) requirements and the hard disk space requirements. For more information, click the following article number 897615 to view the Support policy for Microsoft software running in non-Microsoft hardware virtualization software.

Server Recommendations: Customer Profile 1

This table lists server recommendations

Item Requirements
Customer Profile 1 Usage Use only Financial Series modules
Have between 0-5 concurrent users for Microsoft SQL Server or
for Microsoft SQL Server Express
Process fewer than 250 transactions per day
No web applications in use
Peer to Peer Environment
32-bit x64
Database Requirements Microsoft SQL Server 2019
-Enterprise, Standard or Express
(18.2.1013 GP version or later)
Microsoft SQL Server 2017
-Enterprise, Standard or Express
Microsoft SQL Server 2016
- Enterprise, Standard or Express
Microsoft SQL Server 2014
-Enterprise, Standard or Express

Supported Microsoft SQL
Server Collation
1. Dictionary Order Case
Insensitive - Sort Order 52
In the SQL Server
Management Studio, right-
click the SQL Server Name and click Properties: Server
Collation = SQL_Latin1_General_CP1_CI_AS

2. Binary - Sort Order 50
In the SQL Server
Management Studio, right
-click the SQL Server Name and click Properties:
Server Collation = Latin1_General_BIN
Microsoft SQL Server 2019
-Enterprise, Standard or Express(18.2.1013 GP version or later)
Microsoft SQL Server 2016
-Enterprise, Standard or Express
Microsoft SQL Server 2014
- Enterprise, Standard or Express

Supported Microsoft SQL
Server Collation
1. Dictionary Order Case
Insensitive - Sort Order 52
In the SQL Server
Management Studio, right-
click the SQL Server Name and click Properties: Server
Collation = SQL_Latin1_General_CP1_CI_AS

2. Binary - Sort Order 50
In the SQL Server
Management Studio, right
-click the SQL Server Name and click Properties:
Server Collation = Latin1_General_BIN
Operating System Microsoft Windows Server 2019
Essentials Edition or Standard Edition
18.2.1013 GP version or later
Microsoft Windows Server 2016
Essentials Edition or Standard Edition
Microsoft Windows Server
2012 Essentials Edition or Standard Edition
2012 R2 Essentials Edition or Standard Edition
Processor 1 Dual Core or 2 Single Core Processors 1 Dual Core or 2 Single Core Processors
Minimum Available RAM 2 GB or more 2 GB or more
Netowrk Card 1 GB Ethernet
Virtual Environments Supported (Optional) Hardware Virualization
Windows Server 2019
Hyper-V (18.2.1013 GP version or later
Windows Server 2016 Hyper-V
Windows Server 2012 Hyper-V
Windows Server 2012 R2 Hyper-V

Software Virtualization
Microsoft Application Virtualization (App-V) 5.0

For additional Virtual Technology Support<click the link below
to review the Virtualization Support Policy Wizard.
Choose Dynamics GP as the product

NOTES

  1. When you deploy a system in a virtual environment, make sure that you have sufficient hard disk space to avoid performance problems. Each computer that you deploy in a virtual environment should meet or exceed the random access memory (RAM) requirements and the hard disk space requirements. For more information, click the following article number to view the article in the Microsoft Knowledge Base: 897615 Support policy for Microsoft software running in non-Microsoft hardware virtualization software.

  2. Microsoft SQL Server 2014 Express or Microsoft SQL Server 2016 Express can be installed on a non-server operating system, however it is recommended to install on a server operating system.

  3. Visual Basic for Applications (VBA) is not supported on Windows Server 2019, see BLOG for details.

  4. Verify processors can be upgraded.

  5. If you are going to deploy Intelligent Cloud Insights for Microsoft Dynamics GP, you need to be on Microsoft SQL Server 2016 or later to meet the Compatibility Level 130 required with the April 2019 release.

Server Recommendations: Customer Profile 2

This table lists server recommendations for customer profile 2

Item Requirements
Customer Profile 2 Usage Use only Financial Series modules
Have between 0-20 concurrent users for Microsoft SQL Server or
0-10 concurrent users for Microsoft SQL Server Express
Use Report Writer, Crystal Reports, or Management Reporter
Process fewer than 1000 transactions per day
Import very little data<Dedicated server with Microsoft SQL Server only
Recommend a dedicated server with Microsoft SQL Server<Express only
32-bit x64
Database Requirements Microsoft SQL Server 2019
-Enterprise, Standard or Express
(18.2.1013 GP
version or later
Microsoft SQL Server 2017
-Enterprise, Standard or Express
Microsoft SQL Server 2016
- Enterprise, Standard or Express
Microsoft SQL Server 2014
-Enterprise, Standard or Express

Supported Microsoft SQL
Server Collation
1. Dictionary Order Case
Insensitive - Sort Order 52
In the SQL Server
Management Studio, right-
click the SQL Server Name and click Properties: Server
Collation = SQL_Latin1_General_CP1_CI_AS

2. Binary - Sort Order 50
In the SQL Server
Management Studio, right
-click the SQL Server Name and click
Properties: Server Collation = Latin1_General_BIN
Microsoft SQL Server 2019
-Enterprise, Standard or Express
(18.2.1013 GP
version or later
Microsoft SQL Server 2017
-Enterprise, Standard or Express
Microsoft SQL Server 2016
- Enterprise, Standard or Express
Microsoft SQL Server 2014
-Enterprise, Standard or Express

Supported Microsoft SQL
Server Collation
1. Dictionary Order Case
Insensitive - Sort Order 52
In the SQL Server
Management Studio, right-
click the SQL Server Name and click Properties: Server
Collation = SQL_Latin1_General_CP1_CI_AS

2. Binary - Sort Order 50
In the SQL Server
Management Studio, right
-click the SQL Server Name and click Properties:
Server Collation = Latin1_General_BIN
Operating System Microsoft Windows Server 2019
Essentials Edition or
Standard Edition
(18.2.1013 GP Version or later)
Microsoft Windows Server 2016
Essentials Edition
or Standard Edition
Microsoft Windows Server
2012 R2 Essentials EditionStandard Edition
Microsoft Windows Small Business Server 2008 Premium
Edition SP2 or later
Processor 1 Dual Core or 2 Single Core Processors 1 Dual Core or 2 Single Core Processors
Disk Configuration RAID 1 for operating system
and applications (2 disks)
RAID 5 for SQL database log and
data files (4 disks)
RAID 1 for operating system
and applications (2 disks)
RAID 5 for SQL database log
and data files (4 disks)
Minimum Available RAM 2 GB or more 2 GB or more
Netowrk Card 1 GB Ethernet
Virtual Environments Supported (Optional) Hardware Virualization
Windows Server 2019 Hyper-V
Windows Server 2016 Hyper-V
Windows Server 2012 R2 Hyper-V
Windows Server 2012 R2 Hyper-V

Software Virtualization
Microsoft Application Virtualization (App-V) 5.0

For additional Virtual Technology Support, review the Virtualization Support Policy Wizard. Choose Products GP as the product.

NOTES

  1. Additional disks will improve Microsoft SQL Server performance.

  2. Microsoft SQL Server 2014 Express or Microsoft SQL Server 2016 Express can be installed on a non-server operating system, however it is recommended to install on a server operating system.

  3. Verify processors can be upgraded.

  4. Visual Basic for Applications (VBA) is not supported on Windows Server 2019, see BLOG for details.

  5. When you deploy a system in a virtual environment, make sure that you have sufficient hard disk space to avoid performance problems. Each computer that you deploy in a virtual environment should meet or exceed the random access memory (RAM) requirements and the hard disk space requirements. For more information, click the following article number to view the article 897615 Support policy for Microsoft software running in non-Microsoft hardware virtualization software.

  6. If you are going to deploy Intelligent Cloud Insights for Microsoft Dynamics GP, you need to be on Microsoft SQL Server 2016 or later to meet the Compatibility Level 130 required with the April release.

Server Recommendations: Customer Profile 3

This table lists server recommendations for customer profile 3

Item Requirements
Customer Profile 3 Usage Use Financials Series modules
Use Distribution Series modules moderately
Use Field Service Series modules
Use Manufacturing Series or Project Series modules moderately
Have between 20 and 60 concurrent users
Use Terminal Server
Use Report Writer, Crystal Reports or Management Reporter
Perform some online analytical processing (OLAP) cube generation
Using an import routine/eConnect/Integration Manager
Process between 1000 and 4000 transactions per day
-Originating in Sales (SOP and/or RM), Payables or General Ledger
Dedicated Microsoft SQL Server
32-bit x64
Database Requirements Microsoft SQL Server 2019
-Enterprise, Standard or Express
(18.2.1013 GP version or later)
Microsoft SQL Server 2017
-Enterprise, Standard or Express
Microsoft SQL Server 2016
- Enterprise, Standard or Express
Microsoft SQL Server 2014
Enterprise or Standard

Supported Microsoft SQL
Server Collation
1. Dictionary Order Case
Insensitive - Sort Order 52
In the SQL Server
Management Studio, right-
click the SQL Server Name and click Properties: Server
Collation = SQL_Latin1_General_CP1_CI_AS

2. Binary - Sort Order 50
In the SQL Server
Management Studio, right
-click the SQL Server Name and click Properties:
Server Collation = Latin1_General_BIN
Microsoft SQL Server 2019
-Enterprise, Standard or Express
(18.2.1013 GP version or later)
Microsoft SQL Server 2017
-Enterprise, Standard or Express
Microsoft SQL Server 2016
- Enterprise, Standard or Express
Microsoft SQL Server 2014
Enterprise or Standard

Supported Microsoft SQL
Server Collation
1. Dictionary Order Case
Insensitive - Sort Order 52
In the SQL Server
Management Studio, right-
click the SQL Server Name and click Properties: Server
Collation = SQL_Latin1_General_CP1_CI_AS

2. Binary - Sort Order 50
In the SQL Server
Management Studio, right
-click the SQL Server Name and click Properties:
Server Collation = Latin1_General_BIN
Operating System Microsoft Windows Server 2019
Standard or Datacenter Edition<18.2.1013 GP Version or later)
Microsoft Windows Server
2016 Standard or Datacenter Edition
Microsoft Windows Server
2012 Standard or Datacenter Edition
Microsoft Windows Server
2012 R2 Standard or
Datacenter Edition
Processor 1 Dual Core or 2 Single Core Processors 1 Dual Core or 2 Single Core Processors
Disk Configuration RAID 1 for operating system and applications
(2 disks)
RAID 1 for SQL database
log files (2 disks)
RAID 5 (4 disk minimum)
or RAID 0+1 (8 disk minimum)
for SQL data files
RAID 1 for TempDB (2 disks)
optional, but recommended
RAID 0 for SQL backups
(full and log) (2 disks)
RAID 1 for operating system and
applications (2 disks)
RAID 1 for SQL database log files (2 disks)
RAID 5 (4 disk minimum) or
RAID 0+1 (8 disk minimum)
for SQL data files
RAID 1 for TempDB (2 disks)
-optional, but recommended
RAID 0 for SQL backups
(full and log) (2 disks)
Minimum Available RAM 4 GB or more 4 GB or more
Network Card 1 GB Ethernet
Virtual Environments Supported (Optional) Hardware Virualization
Windows Server 2019 Hyper-V
Windows Server 2016 Hyper-V
Windows Server 2012 R2 Hyper-V
Windows Server 2012 R2 Hyper-V

Software Virtualization
Microsoft Application Virtualization (App-V) 5.0

For additional Virtual Technology Support, review the Virtualization Support Policy Wizard. Choose Products GP as the product.

NOTES

  1. Additional disks will improve Microsoft SQL Server performance.
  2. Verify switch is capable of handling network traffic.
  3. Verify processors can be upgraded.
  4. Visual Basic for Applications (VBA) is not supported on Windows Server 2019, see BLOG for details.
  5. When you deploy a system in a virtual environment, make sure that you have sufficient hard disk space to avoid performance problems. Each computer that you deploy in a virtual environment should meet or exceed the random access memory (RAM) requirements and the hard disk space requirements. For more information, click the following article number to view the article 897615 Support policy for Microsoft software running in non-Microsoft hardware virtualization software.
  6. If you are going to deploy Intelligent Cloud Insights for Microsoft Dynamics GP, you need to be on Microsoft SQL Server 2016 or later to meet the Compatibility Level 130 required with the April release.

Server Recommendations: Customer Profile 4

This table lists server recommendations for customer profile 4

Item Requirements
Customer Profile 4 Usage Use Financials Series and
Distribution Series modules extensively
Use Field Service Series,
Manufacturing Series and Project Series
modules extensively
Have between 60 and 100 concurrent users
Use Terminal Server
Use Report Writer, Crystal Reports
or Management Reporter extensively
Use and import routine extensively-eConnect
Process more than 4000 transactions per day-
Orgininating in Sales (SOP and/or RM),
Payables or General Ledger Perform
online analytical procesing (OLAP)
cube generation (to different machine)
Dedicated Microsoft SQL Server
32-bit x64
Database Requirements Microsoft SQL Server 2019
-Enterprise, Standard or Express
(18.2.1013 GP version or later)
Microsoft SQL Server 2017
-Enterprise, Standard or Express
Microsoft SQL Server 2016
- Enterprise, Standard or Express
Microsoft SQL Server 2014
Enterprise or Standard

Supported Microsoft SQL
Server Collation
1. Dictionary Order Case
Insensitive - Sort Order 52
In the SQL Server
Management Studio, right-
click the SQL Server Name and click Properties: Server
Collation = SQL_Latin1_General_CP1_CI_AS

2. Binary - Sort Order 50
In the SQL Server
Management Studio, right
-click the SQL Server Name and click Properties:
Server Collation = Latin1_General_BIN
Microsoft SQL Server 2019
-Enterprise, Standard or Express
(18.2.1013 GP version or later)
Microsoft SQL Server 2017
-Enterprise, Standard or Express
Microsoft SQL Server 2016
- Enterprise, Standard or Express
Microsoft SQL Server 2014
Enterprise or Standard

Supported Microsoft SQL
Server Collation
1. Dictionary Order Case
Insensitive - Sort Order 52
In the SQL Server
Management Studio, right-
click the SQL Server Name and click Properties: Server
Collation = SQL_Latin1_General_CP1_CI_AS

2. Binary - Sort Order 50
In the SQL Server
Management Studio, right
-click the SQL Server Name and click Properties:
Server Collation = Latin1_General_BIN
Operating System Microsoft Windows Server
2019 Datacenter Edition
(18.2.1013 GP version or later)
Microsoft Windows Server 2016 Datacenter Edition
Microsoft Windows Server 2012
Datacenter Edition<
Microsoft Windows Server
2012 R2 Datacenter Edition
Processor 2 Dual Core or 4 Single Core
Processors
2 Dual Core or 4 Single Core
Processors
Disk Configuration RAID 1 for operating system
and applications (2 disks)
RAID 1 for SQL database log files
(2 disks)
RAID 1 for TempDB (2 disks)
RAID 0 for SQL backups
(full and log) (2 disks)
RAID 0+1 for data files
(8 disks or more)
RAID 1 for operating system
and applications (2 disks)
RAID 1 for SQL database log files
(2 disks)
RAID 1 for TempDB (2 disks)
RAID 0 for SQL backups
(full and log) (2 disks)
RAID 0+1 for data files
(8 disks or more)
Minimum Available RAM 8 GB or more 8 GB or more
Netowrk Card 1 GB Eithernet
Virtual Environments Supported (Optional) Hardware Virualization
Windows Server 2019 Hyper-V
Windows Server 2016 Hyper-V
Windows Server 2012 R2 Hyper-V
Windows Server 2012 R2 Hyper-V

Software Virtualization
Microsoft Application Virtualization (App-V) 5.0

For additional Virtual Technology Support, review the Virtualization Support Policy Wizard. Choose Products GP as the product.

NOTES

  1. Verify processors can be upgraded to 8 processors.

  2. Additional disks will improve Microsoft SQL Server performance.

  3. Verify switch is capable of handling network traffic.

  4. Visual Basic for Applications (VBA) is not supported on Windows Server 2019, see BLOG for details.

  5. When you deploy a system in a virtual environment, make sure that you have sufficient hard disk space to avoid performance problems. Each computer that you deploy in a virtual environment should meet or exceed the random access memory (RAM) requirements and the hard disk space requirements. For more information, click the following article number to view the article 897615 Support policy for Microsoft software running in non-Microsoft hardware virtualization software.

  6. If you are going to deploy Intelligent Cloud Insights for Microsoft Dynamics GP, you need to be on Microsoft SQL Server 2016 or later to meet the Compatibility Level 130 required with the April release.

Remote Desktop Services Requirements

Item Requirements
32-bit x64
Operating System Microsoft Windows Server
2019 Datacenter Edition
(18.2.1013 GP Version or later)
Microsoft Windows Server
2016 Datacenter Edition
Microsoft Windows Server
2012 Datacenter Edition
Microsoft Windows Server
2012 R2 Datacenter Edition
Citrix (Optional) Citrix XenApp Citrix XenApp
Processor 1 Quad Core or 2
Core Processors or highter
1 Quad Core or 2
Core Processors or highter
Disk Configuration RAID 1 for operating
system and applications (2 disks)
RAID 1 for operating system
and applications (2 disks)
Minimum Available RAM 4 GB - Up to 15 concurrent users
8 GB - Up to 30 concurrent users
16 GB - Up to 60 concurrent users
4 GB - Up to 15 concurrent users
8 GB - Up to 30 concurrent users
16 GB - Up to 60 concurrent users
Network Card 1GB Ethernet
Virtual Environments Supported Optional Hardware Virualization
Windows Server 2019 Hyper-V
Windows Server 2016 Hyper-V
Windows Server 2012 R2 Hyper-V
Windows Server 2012 R2 Hyper-V

Software Virtualization
Microsoft Application Virtualization (App-V) 5.0

For additional Virtual Technology Support, review the Virtualization Support Policy Wizard. Choose Products GP as the product.

NOTES

  1. It is recommended to have a dedicated Terminal Server/Citrix Server. There may be performance losses if Microsoft SQL Server is running on the Terminal Server/ Citrix Server. Therefore, it is highly recommended to have two separate servers. One server with Terminal Server and/or Citrix and one server with Microsoft SQL Server.
  2. If using Adobe, Adobe must be installed at the Terminal Server.
  3. If using Lync for Unified Communications, a remote app for Lync must also be configured and copied to the client along with the Microsoft Dynamics GP remote app. The Lync remote app must be launched first and then the Microsoft Dynamics GP remote app.
  4. If accessing Citrix, the hardware and software must be supported according to the Citrix configuration requirements.
  5. Verify processors can be upgraded.
  6. The amount of RAM needed depends on the number of concurrent users per Terminal Server.
  7. Verify switch is capable of handling network traffic.
  8. Increased user count may require greater RAM and Processor speed.
  9. Users utilizing Management Reporter or Crystal reporting via Terminal Services may require increased hardware to increase performance.
  10. Visual Basic for Applications (VBA) is not supported on Windows Server 2019, see BLOG for details.
  11. When you deploy a system in a virtual environment, make sure that you have sufficient hard disk space to avoid performance problems. Each computer that you deploy in a virtual environment should meet or exceed the random access memory (RAM) requirements and the hard disk space requirements. For more information, click the following article number to view the article 897615 Support policy for Microsoft software running in non-Microsoft hardware virtualization software.

Additional Information

  1. This document represents configurations tested by Microsoft Business Solutions and supported by Microsoft Dynamics GP Technical Support. Use of technologies not specified in this document is not recommended and will not be supported. Testing is ongoing, and as newer technologies become supported this list will be updated.

  2. The following are no longer supported with Microsoft Dynamics GP 2018 or later: a. Windows Server 2008 all editions. b. Microsoft SQL Server 2012 all editions.

  3. To review an article regarding support in a virtual environment.
    The following virtual products have been tested: Microsoft Windows Server 2019 Hyper-V, Microsoft Windows Server 2016 Hyper-V, Microsoft Windows Server 2012 Hyper-V, Microsoft Application Virtualization 4.6. For additional Virtual Technology Support, click the link below to review the Virtualization Support Policy Wizard.
    Choose Dynamics GP as the product.

  4. The Microsoft Dynamics GP core application is supported in a peer to peer (workgroup) environment. This environment excludes all web applications such as Web Services, eConnect, and Management Reporter. This also excludes Workflow 2.0 as a domain is required. If web applications are used, a domain is required.

  5. Remote access for Microsoft Dynamics GP is not supported in a WAN or P2P environment due to the possibility of connection and data consistency errors. The only supported options are to either a) Have Microsoft Dynamics GP installed on a Remote Desktop Services machine (with or without Citrix) in the same network as the SQL Server hosting your Dynamics GP databases b) Deploy the Dynamics GP Web Client for extranet access and allow users to log in from remote browsers.

  6. The Analysis Cubes installer is not supported with SQL Server 2019 on Dynamics GP.

  7. Microsoft Dynamics GP is supported in a Windows Azure server environment. For more detail, refer to this doc: Microsoft Dynamics GP 2015 on Windows Azure