Solved

sql server 2005 alter autorization diagram

Posted on 2008-10-18
3
705 Views
Last Modified: 2008-11-22
sql server 2005 alter authorization
0
Comment
Question by:082156r
3 Comments
 
LVL 18

Accepted Solution

by:
sk_raja_raja earned 50 total points
ID: 22749559
To install database diagram support in SQL Server Management Studio, databases must be in SQL Server 2005 database compatibility level. Database compatibility level can be reset after diagram support is installed. If the databases are not in 2005 compatibility level, the following error occurs when you attempt to install diagram support:

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.

To create database diagrams, change the database compatibility level to 2005, install database diagram support, and then return the database to the desired database compatibility level. For more information, search for "sp_dbcmptlevel" in SQL Server Books Online.

Installation of Database Diagram Support Objects Requires a Valid Logon Account

In SQL Server 2005, database diagram support objects will be installed on a database if a member of the db_owner fixed database role performs one of the following operations:
•      Expands the Database Diagrams folder      
•      Creates a new diagram      
•      Explicitly chooses to install the objects from the context menu      
The installation of these support objects can fail on a database that has been attached or restored from another instance of SQL Server. This can occur when the database owner name (stored in the database) is not a valid logon for the instance of SQL Server that the database is being attached or restored to. Use the following Transact-SQL expression to change the database owner to a valid logon for the instance of SQL Server. Then, retry the database diagram operation.

ALTER AUTHORIZATION ON DATABASE::database_name TO valid_login
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question