2

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?

LowlyDBA - John M
  • 10,922
  • 11
  • 42
  • 62
James
  • 2,612
  • 5
  • 26
  • 49

1 Answers1

5

Short answer: start SQL Server with the -m flag from a local admin account.

Step-by-step instructions here:

Forrest
  • 4,159
  • 1
  • 19
  • 31