BuiltIN\Administrator Account burning issue

• sqldba-294117

  Hall of Fame

  Points: 3486

  More actions

  February 21, 2007 at 11:34 am

  #69519

  i have deleted Builtin\Administrator Account accidently & need to add again how i can do that, any help is appreicated & thanking in advance.

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  February 21, 2007 at 11:36 am

  #690992

  Add it the same way you would add any login to SQL Server.

   

   

• Stephen Pierce

  SSC Veteran

  Points: 251

  More actions

  February 22, 2007 at 7:50 am

  #691151

  USE master

  go

  EXEC sp_grantlogin 'BUILTIN\Administrators'

  go

  EXEC sp_defaultdb 'BUILTIN\Administrators', 'master'

  go

  EXEC sp_defaultlanguage 'BUILTIN\Administrators', 'us_english'

  go

  EXEC sp_addsrvrolemember 'BUILTIN\Administrators', 'sysadmin'

  go

  IF EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname='BUILTIN\Administrators')

      PRINT '<<< CREATED LOGIN BUILTIN\Administrators >>>'

  ELSE

      PRINT '<<< FAILED CREATING LOGIN BUILTIN\Administrators >>>'

  go