Database diagram support objects cannot be installed because this database does not have a valid own

Posted Date: 07 Nov 2009	Resource Type: Errors and Solutions	Category: General
Author: Chirag	Member Level: Silver
Rating:	Points: 5

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.

Resolution

1. Right Click on your database, choose properties
2. Goto the Options Page
3. In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2005(90)"
4. Goto the Files Page
5. Enter "sa" in the owner textbox.
6. Hit OK


---------------------
EXEC sp_dbcmptlevel 'yourDB', '90';goALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"gouse [yourDB]goEXECUTE AS USER = N'dbo' REVERTgo
---------------------

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

SQL SERVER 2005 Error . SQL SERVER 2005 Diagram Error . Management Studio Error . Diagram Error . Database diagram support objects . ALTER AUTHORIZATION statement to set the database . Alter Authorization .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to Create Virtual Machine for Windows 2003 Server?
	Previous Resource: NET Error: Implementing property must have matching 'Readonly' or 'Writeonly' specifiers
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

More Resources