Change SA password in SQlserver 2008.

• baabhu

  SSCertifiable

  Points: 6205

  More actions

  January 16, 2012 at 11:19 pm

  #251412

  This is a non production issue. I am the local administrator of my machine. But I do not have access to the sqlserver.

  Buildin administrator access also removed. I don't remember the SA password.

  Is there any easy way to get back the access of the server.

  Any help will be appreciated.

  Thanks.

  -- Babu

• Ignacio A. Salom Rangel

  SSC-Insane

  Points: 20443

  More actions

  January 16, 2012 at 11:24 pm

  #1434412

  baabhu (1/16/2012)

  ---

  This is a non production issue. I am the local administrator of my machine. But I do not have access to the sqlserver.

  Buildin administrator access also removed. I don't remember the SA password.

  Is there any easy way to get back the access of the server.

  Any help will be appreciated.

  Thanks.

  -- Babu

  This link should help you out!

  ---

  
  
  My blog
  

• baabhu

  SSCertifiable

  Points: 6205

  More actions

  January 16, 2012 at 11:43 pm

  #1434422

  Thanks for the link.

  Login failed for user 'XXXXXX\babu.balakrishnan'. Reason: Server is in sing

  le user mode. Only one administrator can connect at this time.

  I am also added in the local administrator group.

  Since I cannot gain the access.

  Could you advise what am I missing?

  Thanks.

  --- Babu

• Ignacio A. Salom Rangel

  SSC-Insane

  Points: 20443

  More actions

  January 17, 2012 at 12:19 am

  #1434434

  baabhu (1/16/2012)

  ---

  Thanks for the link.

  Login failed for user 'XXXXXX\babu.balakrishnan'. Reason: Server is in sing

  le user mode. Only one administrator can connect at this time.

  I am also added in the local administrator group.

  Since I cannot gain the access.

  Could you advise what am I missing?

  Thanks.

  --- Babu

  Just to be sure, try this. Good luck!

  ---

  
  
  My blog
  

• baabhu

  SSCertifiable

  Points: 6205

  More actions

  January 17, 2012 at 1:10 am

  #1434448

  Ignacio A. Salom Rangel (1/17/2012)

  ---

  baabhu (1/16/2012)

  ---

  Thanks for the link.

  Login failed for user 'XXXXXX\babu.balakrishnan'. Reason: Server is in sing

  le user mode. Only one administrator can connect at this time.

  I am also added in the local administrator group.

  Since I cannot gain the access.

  Could you advise what am I missing?

  Thanks.

  --- Babu

  Just to be sure, try this. Good luck!

  I am getting the same issue.

  Login failed for user 'XXXXXX\babu.balakrishnan'. Reason: Server is in sing

  le user mode. Only one administrator can connect at this time.

  Do we need so stop other services running.

  I think I am missing something very basic.

• baabhu

  SSCertifiable

  Points: 6205

  More actions

  January 17, 2012 at 1:22 am

  #1434449

  baabhu (1/17/2012)

  ---

  Ignacio A. Salom Rangel (1/17/2012)

  ---

  baabhu (1/16/2012)

  ---

  Thanks for the link.

  Login failed for user 'XXXXXX\babu.balakrishnan'. Reason: Server is in sing

  le user mode. Only one administrator can connect at this time.

  I am also added in the local administrator group.

  Since I cannot gain the access.

  Could you advise what am I missing?

  Thanks.

  --- Babu

  Just to be sure, try this. Good luck!

  I am getting the same issue.

  Login failed for user 'XXXXXX\babu.balakrishnan'. Reason: Server is in sing

  le user mode. Only one administrator can connect at this time.

  Do we need so stop other services running.

  I think I am missing something very basic.

  Sorry I knew my mistake. SQLserver startup option was already setup with single user mode in the configuration manager. While I try to access using the second method it was throwing the error.

  Now I am able to get the access. Thank you very much for your help.

  This thread is closed.

• Ignacio A. Salom Rangel

  SSC-Insane

  Points: 20443

  More actions

  January 17, 2012 at 1:59 am

  #1434455

  I'm glad to hear that you solved your problem!

  ---

  
  
  My blog