Change SQL SERVER SA password with Windows Admin Account

I received a machine with an instance of SQL Server 2008 installed, I am able to access this instance through SQL Server Management Studio Express with my Windows administrator account but I am unable to perform any action within the instance due to the fact that I do not have permission.

1 - Can i Change Password or delete SA account with Windows ADMIN account?

2-I can give permission from sysadmin to Windows ADMIN account without using the account of SA?

Author: gmsantos, 2014-12-17
Source

2 answers

Dude, I've done this once. I followed the steps detailed in this article: http://community.spiceworks.com/how_to/show/22044-recover-sa-password-on-microsoft-sql-server

In short, the idea is to start the service as a single user. The path is as follows:

  1. Stop SQL Server service

  2. Change the SQL Server Service command line to add option' - m '

  3. Start the service again (now with this command)

  4. Open the sqlcmd with your user and run: 

    EXEC sp_addsrvrolemember 'DOMAIN\Username', 'sysadmin';
GO

  5. Stop the service again, remove the option -m and restart the service

  6. You will have access to reset the SA password

 2
Author: rodrigogq, 2014-12-17 13:54:29

Guy was mass for me worked when I made the password change via cmd Stop SQL Server service Change the SQL Server Service command line to add Option' - m '

Via DOS run sqlcmd-s WIN-D0NTN4PVBFS\SQLEXPRESS go sp_password @ old = null, @new = ' rohto17@', @loginame = 'sa' go value

 -1
Author: user77965, 2017-05-26 16:02:58