August 27, 2006 at 9:07 am
Hi all,
One of my server sql 2005, I still get the error when clicking the Database Diagrams folder:
"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."
Howerver, I changed compatibility level : EXEC sp_dbcmptlevel 'database_name', '90';
And authorization on my database : ALTER AUTHORIZATION ON DATABASE::database_name TO valid_login.
I installed SQL 2005 SP1 on my server.
I don't understand, cause on my other server is work.
Have you got an idea ?
degrem_m
Degremont
August 27, 2006 at 9:15 am
Sorry, I found it. I forgot to choose in database properties my user owner.
In SQL Server Management Studio do the following:
1. Right Click on your database, choose properties
2. Goto the Files Page
3. Enter "my user" in the owner textbox.
degrem_m
Degremont
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply