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
TABLE 1
|
||
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
- 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.
- 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 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
TABLE 2
|
||
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 GO 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
- 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.
- 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.
- Visual Basic for Applications (VBA) is not supported on Windows Server 2019, see BLOG for details.
- Verify processors can be upgraded.
- 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
TABLE 3
|
|||
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
- Additional disks will improve Microsoft SQL Server performance.
- 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.
- Verify processors can be upgraded.
- 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.
- 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
TABLE 4
|
||
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
- Additional disks will improve Microsoft SQL Server performance.
- Verify switch is capable of handling network traffic.
- Verify processors can be upgraded.
- 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.
- 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
TABLE 5
|
||
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
- Verify processors can be upgraded to 8 processors.
- Additional disks will improve Microsoft SQL Server performance.
- Verify switch is capable of handling network traffic.
- 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.
- 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
TABLE 6
|
||
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
- 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.
- If using Adobe, Adobe must be installed at the Terminal Server.
- 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.
- If accessing Citrix, the hardware and software must be supported according to the Citrix configuration requirements.
- Verify processors can be upgraded.
- The amount of RAM needed depends on the number of concurrent users per Terminal Server.
- Verify switch is capable of handling network traffic.
- Increased user count may require greater RAM and Processor speed.
- Users utilizing Management Reporter or Crystal reporting via Terminal Services may require increased hardware to increase performance.
- 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
- 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.
- 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.
- 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. - 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.
- 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.
- The Analysis Cubes installer is not supported with SQL Server 2019 on Dynamics GP.
- 01/15/2021
- 18 minutes to read