what happens if i delete BUILT/IN Adminstrator

• nvkumar12

  SSC-Addicted

  Points: 455

  More actions

  July 2, 2010 at 9:59 am

  #226408

  Hi friends

  i suddenly deleted built/in admin ,so what should i do and what is the solution for this

  Thanks

  Kushi;-)

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  July 2, 2010 at 10:39 am

  #1188349

  Do you have another sysadmin login (windows authentication or SQL authentication)?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  July 2, 2010 at 11:11 am

  #1188369

  You can use sa to connect, or the DAC if it's enabled.

  There's also this: http://technet.microsoft.com/en-us/library/dd207004.aspx

• Jeffrey Williams

  SSC Guru

  Points: 90303

  More actions

  July 2, 2010 at 3:15 pm

  #1188437

  You can add your domain account to the SQL Server specific local windows group. That group should have sysadmin rights and allow you to login to the system to fix this issue.

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs