Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

One of our clients has an installation of SQL Server Express 2008 R2 that we more or less manage for them. Today I need to create a new database(a fairly rare occurrence). So I go to login as the user we usually use and we don't have permission to create databases.. No biggie, just remote desktop and login as Administrator locally to create a new user for this....

Well, turns out the latest version of SQL Express stopped providing the BUILTIN\Administrator login... There is the sa account, but no one can remember what the password is.

How can I reset the password for sa or enable the BUILTIN\Administrator login?

share|improve this question

2 Answers 2

up vote 6 down vote accepted

If Jason's suggestion doesn't work, restart the SQL Instance in single user mode and everyone in the local admin group should now have sysadmin rights so you can get into the system and fix the permissions.

share|improve this answer

There should be a local group created called SQLServerMSSQLUser$$SQLEXPRESS on the machine. Add the user to that, restart SQL service and then log off/back on and you should have the needed access. Then you can add the administrators group to the instance explicitly.

share|improve this answer
1  
That didn't work. I ended up having to restart into single user mode –  Earlz Dec 7 '11 at 3:45
    
It didn't work for me either, but in fairness, I think I forgot to log off/on before checking it. –  johntrepreneur Aug 12 at 0:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.