Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is the best account for dbo user? I mean that if I use personal AD account for database owner, and if this account is removed from AD (e.g if I leave my job), these databases are not accessible. I have heard that there is also problems using "sa" account in dbo.

share|improve this question
up vote 0 down vote accepted

dbo is a "user" (a security principal at the database level) and is listed in sys.database_principals

It isn't the database owner mentioned in sys.databases.owner_sid. This column is at the server level and matches an entry in sys.server_principals, specifically the sid column.

For ease of use, just make the owner sa. There are no major issues with doing this.

share|improve this answer

Create a separate account for that, something like SQLadmin. Give it only the permissions it needs in AD, and whatever it needs for SQL.

share|improve this answer

Your Answer


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.