I have a client that currently has 6 users. He has a Windows 2003 server running MS SQL 2008. We are replacing the server and it has Windows 2012 and will be running MS SQL 2014.
I have been told that I cannot run the MS SQL 2014 server that is a Domain Controller. My options are:
1)Install a second applications server to run the SQL. My client space Is so small that he does not want a second server.
2) Install the main server as a "Workgroup Server" rather than a Domain Controller. On that note I have been told maintaining domain rights and rules is a nightmare with a Workgroup server.