SQL Server Performance

forgot sql password...

Discussion in 'ALL SQL SERVER QUESTIONS' started by lara999, Oct 16, 2012.

  1. lara999 New Member

    1.i forgo my sa passowrd..i dont have any other access to sql server...what are my options to get reset the password?...
  2. Luis Martin Moderator

    Do you have databases backups?
  3. Shehap MVP, MCTS, MCITP SQL Server

    Likelihood , you still have a fair chance to come out of this incident ,as you may have the follow options :

    · If you are using local Account or AD account for your SQL Server installation, you can use it for connecting SQL Server and reset SA password or local Administrator group

    · If you are already granting sysadmin privileges for Local Administrators groups, you can add your account to this group and connect SQL Server

    Despite of that , it is heavily recommended to disable SA user to mitigate SQL injection risks and much better to create other AD credentials having sysadmin to be used for administrative tasks instead of SA credential

    Kindly work out the above options and let me know your feedback

Share This Page