No sql account for login

• k.thanigaivel

  Ten Centuries

  Points: 1247

  More actions

  November 9, 2011 at 9:42 am

  #251521

  Hi all,

  unfortunate I deleted all the login account from my sql server. It denies dedicated admin and administrator every thing. there is no account in active mode(sa already in disable mode). how could i get login in? Please help us.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 9, 2011 at 9:47 am

  #1405340

  Try what's suggested in this blog post

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Lowell

  SSC Guru

  Points: 323518

  More actions

  November 9, 2011 at 9:56 am

  #1405354

  you'll need to start the server in single user mode, and add yourself as an administrator again, then put the serve back to normal.

  fromt ehre, you can connect and start adding logins, change the sa password, whatever.

  http://www.bradg.co.za/?p=51

  or

  http://beyondrelational.com/blogs/chintak/archive/2010/07/20/sql-2008-r2-new-installation-and-login-password-unknown.aspx

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• k.thanigaivel

  Ten Centuries

  Points: 1247

  More actions

  November 9, 2011 at 8:57 pm

  #1405492

  Hi,

  Thanks lot, it is working...