Search code examples
sql-serverpasswordssa

Forgot SA password and user in Administrators account can't change it?

I have a local install of SQLExpress that I haven't touched in months. Now I need to use it, and I've forgotten the SA password.
That would be fine, except that my local user which IS a member of the local Administrators Group apparently doesn't have permission to change the SA password or permissions to change my own User Rights.

I have tried using SQL Server Management Studio, I have done Single User Mode with SQL Server and used sqlcmd, they all tell me I don't have permissions for it.

I'm afraid that even reinstalling SQL Express isn't going to fix this for me. Does anyone know of any other route I could take here?

Solution

  • I would just uninstall and then reinstall -- it's not a very lengthy process. I believe you will be presented with the option to setup your sa account on the new installation.