Friday, November 30, 2012 4:24 PMWhat are the options and/or limits for running SQL server (Standard or Express, 2012 or 2008 or 2005) on Server 2012 Essentials? Thank you.
Friday, November 30, 2012 11:11 PM
Most best practice is that it is not a good idea to run SQL on a DC. However, I am not aware of any negatives, other than the disclaimers about it being a DC and possible RAM or I/O issues. Were possible, I would use Express as it is a LOT less expensive and requires fewer resources. It was only a generation or two ago that SQL and Exchange and ISA server all ran on "the" DC and could not be relocated by EULA, for up to 75 users.
From this document:
Follow the Learn More at the bottom, for a pdf that reads, in part:
Q: What applications can I run on Windows Server 2012 Essentials?
A: Almost all Windows Server 2012 applications should run on Windows Server 2012 Essentials. Windows Server
2012 Essentials differs from Windows Server 2012 primarily in that several of the roles and features of Windows
Server are automatically installed and configured according to best practices for a small business environment. In
some cases, an application that is designed to run on Windows Server 2012 may require that specific roles and/or
features are not enabled. See the manufacturer’s product information for specific details.
Do NOT take what I am about to say as gospel... I am NOT a SQL expert. But imo, the reason to not run SQL server on the DC is that it is busy enough and in an AD enviornment where there are potentially thousands of users the server would be too busy servicing those requests to be a good candidate for SQL. But in network of 25 users or less..... ??
- Marked As Answer by EdBranson Monday, December 03, 2012 10:21 PM