Sign in
 
HomeWindows Server 2012Windows Server 2008 R2Windows Server 2003LibraryForums
Windows Server TechCenter >
> 
> 
SQL on Server 2012 Essentials

Answered SQL on Server 2012 Essentials

  • Friday, November 30, 2012 4:24 PM
     
     
    Sign In to Vote
    0
    What are the options and/or limits for running SQL server (Standard or Express, 2012 or 2008 or 2005) on Server 2012 Essentials? Thank you.
     

All Replies

  • Friday, November 30, 2012 11:11 PM
     
     Answered
    Sign In to Vote
    0

    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:

    http://www.microsoft.com/en-us/server-cloud/windows-server-essentials/default.aspx

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

    Larry Struckmeyer[SBS-MVP]

    • Marked As Answer by EdBranson Monday, December 03, 2012 10:21 PM
    •