Should sql be installed by the account that will be running it?

Question

Should sql be installed by the account that will be running it?

WayneS

SSC Guru

Points: 95460
More actions
August 11, 2010 at 8:47 am

#236483

I know that MS says that Setup.exe needs to be run by an administrator. However, I've had several people say that you should either log in as the service account that will be running sql to do the installation, or to use "Run As" to run Setup.exe as the service account.
Does anyone have any insight as to whether Setup.exe should be run like this?
Thanks!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 1

Absolutely not, your Server Account should only be User level permission account. There is no need to grant admin level permission to a service account.

You must install the application using an admin level account to make sure that everything can install correctly.

Andrew SQLDBA

WayneS SSC Guru Points: 95460 More actions · Answer 2

I agree. Makes me wonder if this might have been something that was discovered in one of the older versions of SQL... 6.5/7 and you know how people hang on to things from back then.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 3

I don't remember it, even from 4.2

You get the jest of how to configure the SQL Service accounts.

Andrew SQLDBA

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

the service account should be low permisson. Setup grants all necessary permissions to the account (logon as service, etc) during install hence why you need to execute setup with admin privileges or administrator account, not the service account.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉