Post reply

SQL Server 2005 running as a Local Admin account

  • May 1, 2008 at 4:28 pm

    #121739

    Hi,

    I have read the "Picking Service Accounts" article and yes you guessed it we are running most of our SQL servers as a local admin account.

    On new SQL installation we have no problem as the SETUP takes care of this, however, in an already existing SQL 2005 server environment how can I change the account to a normal user account and not the administrator account? Is there an tips on doing this?

    Thanks

  • May 1, 2008 at 8:39 pm

    #809898

    Use SQL Server Configuration Manager. It should take care of any permissions the designated account requires. All you should have to do is type in the name & password.


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

  • May 2, 2008 at 12:57 pm

    #810302

    Thanks for your help, I'll test it tomorrow and let you know.

Viewing 3 posts - 1 through 2 (of 2 total)

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