Home / server / Questions / 884480
In Process
Digital Lightcraft
Asked: 2017-11-22 07:18:25 +0800 CST

MSSQL Server database owner is a disabled user

  • 772

I am troubleshooting a slow MS SQL server setup currently, and on entering into the properties of one of the databases (in SQL Server Management Studio -. Database -> Properties -> Files) I notice that the database "Owner" is set to a domain admin account that is currently disabled.

Is this likely to cause any problems?

Is there any reason I should or shouldn't change it to something else?

enter image description here

sql-server

2 Answers

  1. The disabled user shouldn't cause issues but if it's removed from AD sp_helpdb will start throwing an error. Changing the owner takes some testing to make sure you don't break any applications or processes using the database.

    • 0

  2. You can change the owner to SA by executing the following command:

    exec databasename.dbo.sp_changedbowner 'sa'

    • -1