January 6, 2017 at 11:40 am
Hello SSC,
When it comes to installing SQL Server 2012 (or 2008R2 & up), does it matter which account you use to run the install under?
Fact 1:
domain\SQL_service_account will be running all services (engine, agent, etc.). This account would not be going away.
Fact 2:
My user account, domain\edwardj will be leaving the company someday.
Are there any problems in the configurations, registry, services, binaries, anything that would be bad if I installed SQL Server with my named account? My gut says that that installing under my named account is also best practice, but I cannot find anything to support this thought.
Thanks!
Dan
January 6, 2017 at 11:50 am
The account used to logon to the server and install the software must be a server administrator.
The account used to run the service should be a low privilege user account.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2017 at 1:52 pm
So all that matters, as far as SQL Server is concerned, is that the installing account is a server admin at the time of install. After that point anything can be done to the initial installing account without causing any fallout with SQL Server (i.e. removed from server admin group, deleted from active directory, etc.).
Correct?
January 6, 2017 at 1:59 pm
Correct.
The user installing needs to be a local admin on the server. If you are creating a cluster or always on, you need to be a domain admin.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 6, 2017 at 2:05 pm
Thanks Perry & Michael!
January 8, 2017 at 11:10 am
Michael L John (1/6/2017)
Correct.The user installing needs to be a local admin on the server. If you are creating a cluster or always on, you need to be a domain admin.
You don't need to be a domain admin and in fact you shouldn't be.
You would need an AD admin to pre stage the Cluster Name Object and configure the accounts permissions
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply