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
  • 11,059
  • 11
  • 45
  • 63
James
  • 2,668
  • 5
  • 28
  • 51

1 Answers1

5

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

Step-by-step instructions here:

Forrest
  • 4,189
  • 1
  • 20
  • 31