Post reply

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

  • 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

  • August 11, 2010 at 9:06 am

    #1205426

    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

  • August 11, 2010 at 10:03 am

    #1205493

    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

  • August 11, 2010 at 10:07 am

    #1205499

    I don't remember it, even from 4.2

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

    Andrew SQLDBA

  • August 15, 2010 at 11:17 am

    #1207092

    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" 😉

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

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