Change SQL SERVER SA Password with Windows Admin Account

Asked

Viewed 10,106 times

1

I received a machine with an instance of SQL Server 2008 installed, I can access this instance through SQL Server Management Studio Express with my Windows administrator account but I can’t perform any action within the instance due to not having permission.

1 - I can change the password or delete the SA account with the Windows ADMIN account?

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

sql database security-guard

  • user SA is enabled?

  • Yes is Enabled, the SA is the only sysadmin of the instance, and the user has lost password.

2 answers

2


Dude, I already did it once. I followed the detailed steps 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 the SQL Server service

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

  3. Restart service (now with this command)

  4. Open the sqlcmd with your user and run: 

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

  5. Re-stop the service, remove the option -m and restart the service

  6. You will have access to reset the SA password

  • 1

    Thank you very much man, it worked!

-1

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

via DOS run sqlcmd -S WIN-D0NTN4PVBFS SQLEXPRESS go sp_password @old = null, @new = rohto17@', @loginame = 'sa' go thanks

Browser other questions tagged sql database security-guard

You are not signed in. Login or sign up in order to post.