I received a machine with an instance of SQL Server 2008 installed, I can access that instance through SQL Server Management Studio Express with my Windows administrator account but I can not take any action within the instance due to not having permission.
1 - Can I change the password or delete the SA account with the Windows ADMIN account?
2 - Can I give sysadmin permission to the Windows ADMIN account without using the SA account?
Man, I've done it once. I followed the steps detailed in this article: link
In summary, the idea is to start the service as a single user. The path is as follows:
Stop the SQL Server service
Change the command line of the SQL Server service to add '-m' option
Restart service (now with this command)
Open sqlcmd with your user and execute:
EXEC sp_addsrvrolemember 'DOMAIN\Username', 'sysadmin';
GO
Stop the service again, remove the -m option and restart the service
You will have access to reset the SA password
Dude it was mass for me it worked when I did the password change via cmd Give a stop in the SQL Server service Change the command line of the SQL Server service to add '-m' option
DOS run sqlcmd -S WIN-D0NTN4PVBFS \ SQLEXPRESS go sp_password @old = null, @new = 'rohto17 @', @loginame = 'sa' go Thanks.