permissions

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  November 19, 2012 at 6:23 am

  #393630

  i need to add user as sys admn in sql express as there is no management studio installed , how can we add ?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 19, 2012 at 8:11 am

  #1560385

  I see no connection between "no management studio installed" and "user needs sysadmin rights".

  Am I missing something?

  Management studio is available in the Express flavor for the first issue.

  For the second one, just issue:

  EXEC master..sp_addsrvrolemember @loginame = N'someLoginNameGoesHere', @rolename = N'sysadmin'

  -- Gianluca Sartori