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.

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
add comment

2 Answers 2

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
add comment

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
add comment

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.