• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2232
  • Last Modified:

SQL Express Authentication - Reset passord

I installed SQL Express on my workstation some time ago and don't remember what password I assigned to sa.

I can login using Windows authentication, but it doesn't allow me to do any operations, such as add a database. Is there a way to reset the password, or do I have to remove and reinstall SQL in order to proceed.?

Thanks in advance!
  • 2
1 Solution
Unfortunately the answer to this is no. You will have to un-install and reinstall. If you make a backup copy of any user database files you have, you can use sp_attach_db to reattach them to the new installation.
AndrewJenAuthor Commented:
Thank you. Oddly enough, I am logging in via Windows Authentication and I am an Admin on my local machine where this is installed. Isn't this supposed to give me admin privileges on the DB server?
It should unless the builtin\administrators group has been removed or been removed from the sysadmin role.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now