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
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
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
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
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
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.
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.