SMB Server Requirements for Company with up to 20 UsersItemRequirementsCustomer Profile 2 UsageUse 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-bitx64Database RequirementsMicrosoft SQL Server 2016 -Enterprise, Standard or Express Microsoft SQL Server 2014 -Enterprise, Standard or Express Microsoft SQL Server 2012 – 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_BINMicrosoft SQL Server 2016 -Enterprise, Standard or Express Microsoft SQL Server 2014 -Enterprise, Standard or Express Microsoft SQL Server 2012 – 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_BINOperating SystemMicrosoft Windows Server 2008 Standard Edition SP2 or later Microsoft Windows Small Business Server 2008 Premium Edition SP2 or laterMicrosoft Windows Server 2016 Essentials Edition or Standard Edition Microsoft Windows Server 2012 Essentials Edition or Standard Edition Microsoft Windows Server 2012 R2 Essentials Edition or Standard Edition
Microsoft Windows Server 2008 R2 Standard Edition SP1 or later Microsoft Windows Server 2008 Standard Edition SP2 or laterProcessor1 Dual Core or 2 Single Core Processors1 Dual Core or 2 Single Core ProcessorsDisk ConfigurationRAID 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 RAM2 GB or more2 GB or moreNetwork Card1GB EthernetVirtual 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, click the link below to review the Virtualization Support Policy Wizard. Choose Products to see if your Virtual Technology is listed.http://www.windowsservercatalog.com/svvp.aspx?svvppage=svvpwizard.htm
NOTES 1. The following are no longer supported with Microsoft Dynamics GP 2016: a. Microsoft Office 2010 32bit & x64 2. Microsoft SQL 2008 Express and Microsoft SQL Server 2012 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. Additional disks will improve Microsoft SQL Server performance. 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 in the Microsoft Knowledge Base: 897615 Support policy for Microsoft software running in non-Microsoft hardware virtualization software.
For more information, please contact us at Sales@CBRTechnology.com or by calling Tel. (855) 227-0700 .
