System Requirements for Microsoft Dynamics GP
Overview
This page lists the system requirements for Microsoft Dynamics GP 2018 and Microsoft Dynamics GP (18.2, 18.3, 18.4, 18.5, 18.6 and later).
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 | 32-bit Requirements | x64 Requirements |
|---|---|---|
| Operating System | Microsoft Windows 11 (18.4.1434 GP version or later) Professional Edition Microsoft Windows 11 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 11 (18.4.1434 GP version or later) Professional Edition Microsoft Windows 11 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 |
| Network Card | 1 GB Ethernet | |
| Microsoft Office 32-bit & x64 |
Microsoft Office 2016 32bit & x64 Microsoft Office 2019 32bit & x64 Microsoft Office 2022 32bit & X64 Office 365 NOTES: 1. If using Office x64, the server type in System Preferences (Microsoft Dynamics GP>Tools>System>Setup>System Preferences) must be set to Exchange. 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 can either be MAPI or Exchange 4. Microsoft Dynamics GP 18.3 and later releases only supports Exchange 2013 or later. Check out email troubleshooting guide. |
|
| 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 If TLS 1.2 is enabled, try to download a compatible SQL Native Client |
|
| 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. If TLS 1.2 is enabled, please see this blog - KB3135244 - TLS 1.2 support for Microsoft SQL Server
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 | General 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 |
| Item | 32-bit Requirements | x64 Requirements |
|---|---|---|
| Database Requirements | 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 - Enterprise, Standard or Express - GP 2018 supports SQL 2017, 2016 and 2014 - GP 18.2 and later supports SQL 2019 plus SQL 2017, 2016 and 2014 - GP 18.5 and later supports SQL 2022, 2019, 2017 and 2016 - GP 18.7 and later supports SQL 2022, 2019, and 2017 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 2022 Essentials Edition or Standard Edition (18.5.1556 GP version or later) 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 |
| Network Card | 1 GB Ethernet | |
| Virtual Environments Supported (Optional) | Hardware Virtualization 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.
Server Recommendations: Customer Profile 2
This table lists server recommendations for customer profile 2
| Item | General 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 |
| Item | 32-bit Requirements | x64 Requirements |
|---|---|---|
| Database Requirements | 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 - Enterprise, Standard or Express - GP 2018 supports SQL 2017, 2016 and 2014 - GP 18.2 and later supports SQL 2019 plus SQL 2017, 2016 and 2014 - GP 18.5 and later supports SQL 2022, 2019, 2017 and 2016 - GP 18.7 and later supports SQL 2022, 2019, and 2017 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 2022 Essentials Edition or Standard Edition (18.5.1556 GP version or later) 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 Edition or Standard 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 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 |
| Network Card | 1 GB Ethernet | |
| Virtual Environments Supported (Optional) | Hardware Virtualization 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.
Server Recommendations: Customer Profile 3
This table lists server recommendations for customer profile 3
| Item | General 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 |
| Item | 32-bit Requirements | x64 Requirements |
|---|---|---|
| Database Requirements | 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 - Enterprise, Standard or Express - GP 2018 supports SQL 2017, 2016 and 2014 - GP 18.2 and later supports SQL 2019 plus SQL 2017, 2016 and 2014 - GP 18.5 and later supports SQL 2022, 2019, 2017 and 2016 - GP 18.7 and later supports SQL 2022, 2019, and 2017 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 2022 Standard or Datacenter Edition (18.5.1556 GP version or later) Microsoft Windows Server 2019 Standard or Datacenter Edition (18.5.1556 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 Virtualization 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.
Server Recommendations: Customer Profile 4
This table lists server recommendations for customer profile 4
| Item | General 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- Originating in Sales (SOP and/or RM), Payables or General Ledger Perform online analytical processing (OLAP) cube generation (to different machine) Dedicated Microsoft SQL Server |
| Item | 32-bit Requirements | x64 Requirements |
|---|---|---|
| Database Requirements | 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 - Enterprise, Standard or Express - GP 2018 supports SQL 2017, 2016 and 2014 - GP 18.2 and later supports SQL 2019 plus SQL 2017, 2016 and 2014 - GP 18.5 and later supports SQL 2022, 2019, 2017 and 2016 - GP 18.7 and later supports SQL 2022, 2019, and 2017 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 2022 Standard or Datacenter Edition (18.5.1556 GP version or later) Microsoft Windows Server 2019 Standard or Datacenter Edition (18.5.1556 GP version or later) 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 |
| Network Card | 1 GB Ethernet | |
| Virtual Environments Supported (Optional) | Hardware Virtualization 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.
Remote Desktop Services Requirements
| Item | 32-bit Requirements | x64 Requirements |
|---|---|---|
| Operating System | Microsoft Windows Server 2022 Essentials Edition or Standard Edition (18.5.1556 GP version or later) 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 higher |
1 Quad Core or 2 Core Processors or higher |
| 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 Virtualization 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 accessing Citrix, the hardware and software must be supported according to the Citrix configuration requirements.
4. Verify processors can be upgraded.
5. The amount of RAM needed depends on the number of concurrent users per Terminal Server.
6. Verify switch is capable of handling network traffic.
7. Increased user count may require greater RAM and Processor speed.
8. Users utilizing Management Reporter or Crystal reporting via Terminal Services may require increased hardware to increase performance.
9. Visual Basic for Applications (VBA) is not supported on Windows Server 2019, see BLOG for details.
- 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. 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.
3. 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.
4. 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.
5. Microsoft Dynamics GP is supported in a Windows Azure server environment. For more detail, refer to Microsoft Dynamics GP on Microsoft Azure
6. Here is a cheat sheet for SQL versions and what is supported per Dynamics GP version:
- GP 2013 supports SQL 2014, 2012 and 2008
- GP 2015 supports SQL 2014 and 2012
- GP 2016 supports SQL 2016, 2014 and 2012
- GP 2018 supports SQL 2017, 2016 and 2014
- GP 18.2 and later supports SQL 2019 plus SQL 2017, 2016 and 2014
- GP 18.5 and later supports SQL 2022, 2019, 2017 and 2016
- GP 18.7 and later supports SQL 2022, 2019, and 2017