On my local machine I have SSMS (SQL Server 2008 R2).
xxxx Server Roles are only
When I try to change it to
sysadmin it throws the error:
User does not have permission to perform this action. (.Net SqlClient Data Provider)
Error Code 15247
- Server type (local)/SQLExpress
- Authentication: Windows Authentication
- User: ComputerName\username (disabled)
- Password: none (disabled)
How can I do this?
The user I am connecting with server role is:
public, but Windows Admin user.
The instance is configured for mixed mode authentication, but I don't remember the password for
sa. I can't change the password because I am not
Is there any way I can create a
sysadmin user account or make my account
sysadmin and get full control of my SSMS?