Locked out of an old 2008R2 Database We just discovered another server with a database on it. The database is owned by a SQL account SA, with the public and sysadmin roles. The other login is BUILTIN\Users, with only public. I can only connect through this one. SA is disabled, and even if it wasn't, we might not know the password.

Question: Is there any way to enable SA, or create another sql login with sysadmin?
Short answer: start SQL Server with the -m flag from a local admin account.

Step-by-step instructions here: