• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

SQL 2008 lost SA password

Is there a simple way to recover the sa password?  The database uses both windows and sql server authentication, can get into the system but am trying to get back sys admin permissions.
0
Jack_son_
Asked:
Jack_son_
5 Solutions
 
AmmarRCommented:
hi Jack_son_

usually all users in the windows administrators group are by default in the SQL sysadmin group

so you can create a user in windows and keep it in Administrators group, login with it to SQL and change your sa password.

Regards
0
 
Parth MalhanPrincipal EngineerCommented:
Try using Following Steps.

Login to Windows with an administrator account
Login to SQL with Windows Authentication.
Expand Server - > Security - > Logins - > sa
Right-Click sa and select Properries.
NOTE:
You Must have Administration Privillages on the Local Computer.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Alpesh PatelAssistant ConsultantCommented:
Reset SA password. from SSMS, or computer management (Users & Groups)
0
 
Jack_son_Author Commented:
the bulletin\admin group seems to only have public access and unable to reset the password.  Is there perhaps another way?
0
 
AmmarRCommented:
if you are in a network (domain) All domain administrators will have full sysadmin, ask any network admin to add back your BUILTIN\Administrators to sysadmin or just directly reset you SA
0
 
AmmarRCommented:
if your not in a Domain, i guess you have 1 option left before reinstalling.

1. Connecting to SQL Server When System Administrators Are Locked Out
http://msdn.microsoft.com/en-us/library/dd207004.aspx

or the link mentioned by kaminda: Answer ID: 35502665
0
 
Jack_son_Author Commented:
no, i am a domain admin, i see bulletin/Administrator but they have  only public access not sa.
0
 
AmmarRCommented:
Did you try to login with your domain admin account to sql
0
 
Jack_son_Author Commented:
yes, it still wont give me sa access.  How can i get a backup of it?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now