How to Fix This Database Does Not Have a Valid Owner in Mssql
I encountered the error below when creating a diagram in the Management Studio. "Database diagram support objects cannot be installed...
https://www.czetsuyatech.com/2021/07/mssql-this-database-does-not-have-a-valid-owner.html
I encountered the error below when creating a diagram in the Management Studio.
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
Solution:
Execute the following line in SQL Server Management Studio Express Query
ALTER AUTHORIZATION ON DATABASE::DATABASE_NAME TO "Your_User"
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
Solution:
Execute the following line in SQL Server Management Studio Express Query
ALTER AUTHORIZATION ON DATABASE::DATABASE_NAME TO "Your_User"
Post a Comment