Database diagram support objects cannot be installed

When attaching a new database from someone else, you could see an error pop up when trying creating a diagram, it is caused by the dbo of the attaching database doesn’t have a login.

Perform the following steps could resolve the issue,

USE [master]
EXEC sp_dbcmptlevel 'DatabaseName', '90';
ALTER AUTHORIZATION ON DATABASE::"DatabaseName" TO "UserName"
EXECUTE AS USER = N'dbo' REVERT

To check your database compatibility level,

EXEC sys.SP_DBCMPTLEVEL 'DatabaseName'

compatibility level and MSSQL version mapping,

• 60 = MSSQL 6
• 65 = MSSQL 6.5
• 70 = MSSQL 7
• 80 = MSSQL 2000
• 90 = MSSQL 2005
• 100 = MSSQL 2008

One Response to “Database diagram support objects cannot be installed”