July 14, 2013 at 12:31 pm
I have just installed Windows Server 2012 essentials on my HP Mediasmart server. I am going to be using server primarily for testing my ASP.Net applications. There will only be a couple of users on this server at any time, myself and one other person.
When I try to install any version of SQL Server, 2008, 2012, 2012 Express, the installer gives me the warning about "SQL server on a domain controller is not recommended". The installer lets me get past that message. The issue comes up when I have to select the accounts for each of the services and components.
On the SQL Server express install, it will not let me select the one of the "Default" service accounts (NTAUTHORITY\LocalService) for the database engine.
Can someone give me an example account setup that I can create in active directory on my domain, with limited permissions, that I can then use in the SQL server installer?
July 15, 2013 at 9:03 am
Hi,
The message appears because the server where you're deploying SQL Server is a Domain controller, so it recommends not to install on this server and also you cannot run the SQL services under a local service account or a network service account (because this is a domain controller) must run on a domain account.
Preferably install on a separate server.
Regards,
July 15, 2013 at 1:52 pm
Thanks for the reply!
I actually got SQL Server 2012 Express installed without any problems. That is all I need, I will not be doing any designing or admin tasks on the SQL server. I just need the DB there for my ASP.Net application to run.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply