Give sysadmin privilege to local administrators group during installation

• neelsmail

  Old Hand

  Points: 320

  More actions

  May 14, 2010 at 9:25 am

  #232596

  Hi-

  This probably is a very simple question:

  During sql express 2008, I want to create a new instance (other than SQLExpress). I need to give local administrators sysadmin role on THIS NEW INSTANCE. I think there should be a way to do that during installation instead of running script afterwards. Somehow the logical step seems to be either "Server Configuration" -> "Service Accounts" or "Database Engine Configuration" -> "Account Provisioning" tab but I am not sure which. Could you help?

  Thanks in advance for your help,

  -Neel.

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  May 15, 2010 at 1:35 pm

  #1167955

  you have the option to provision accounts during the install, why not use that?

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

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

• chandu.ade

  Mr or Mrs. 500

  Points: 538

  More actions

  May 18, 2010 at 7:23 am

  #1168800

  you can add administrators while installation process.

  Chandu