Čitajte na engleskom

Dijeli putem


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.

  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 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