17 Oct 2011

Database does not have a valid owner

 

Error Message:

“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. "

“Database diagram support objects cannot be installed because this database does not have a valid owner.”

Solution:

USE [<DatabaseName>]
GO
EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
GO

No comments:

Post a Comment