SMB Server Requirements for Company with up to 20 Users

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

 Microsoft 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_BIN
Operating
System		 Microsoft Windows Server
2008 Standard Edition SP2 or
later
Microsoft Windows Small
Business Server 2008 Premium
Edition SP2 or later		 Microsoft 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 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
Network
Card		 1GB Ethernet
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, 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 . 

Posted by:CBR Technology Corp. - Christoph Riechert

Dynamics 365 Business Central, Dynamics NAV, and QuickBooks Enterprise certified Solution Provider specializing in the deployment and implementation of these ERP, CRM and eCommerce solutions for the distribution/wholesale and manufacturing industries.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s