15404 sql ошибка когда создаю диаграмму

I tried to create a database diagramm with SQL Server 2008, but an error occurs:

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.

Then I tried the following:

EXEC sp_dbcmptlevel 'Ariha', '90';
GO
ALTER AUTHORIZATION ON DATABASE::Ariha TO [WIN-NDKPHUPPNFLAdministrator]
GO
USE Ariha
GO
EXECUTE AS USER = N'dbo' REVERT
GO

Next erorr pops up:

Msg 15404, Level 16, State 11, Line 1
Could not obtain information about
Windows NT group/user
‘WIN-NDKPHUPPNFLAdministrator’, error
code 0x534.

The Problem is the name of the PC has changed into «DevPC» I also changed this in the update script, but still the same error 15404.

What can I do to fix this annoying error?

Enter «SA» instead of «sa» in the owner textbox. This worked for me.

I had the same problem.
I wanted to view my diagram, which I created the same day at work, at home. But I couldn’t because of this message.
I found out that the owner of the database was the user of my computer -as expected. but since the computer is in the company’s domain, and I am not connected to the company’s network, the database couldn’t resolve the owner.

So what I did is change the owner to a local user and it worked!!
Hope this helps someone.

You change the user by right-click on the database, properties, files, owner

answered Jul 4, 2016 at 22:46

This fixed it for me. It sets the owner found under the ‘files’ section of the database properties window, and is as scripted by management studio.

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

According to the sp_changedbowner documentation this is deprecated now.

Based on Israel’s answer. Aaron’s answer is the non-deprecated variation of this.

answered Oct 16, 2014 at 10:33

I just experienced this. I had read the suggestions on this page, as well as the SQL Authority suggestions (which is the same thing) and none of the above worked.

In the end, I removed the account and recreated (with the same username/password). Just like that, all the issues went away.

Sadly, this means I don’t know what went wrong so I can’t share any thing else.

answered Mar 7, 2015 at 16:12

1.Right click on your Database ,
2.Then select properties .
3.Select the option in compatibility levels choose sql 2008[100] if you are working with Microsoft sql 2008.

4.Then select the file and write ( sa ) in owner`s textbox

100% works for me.

answered May 5, 2015 at 14:56

answered Jun 2, 2015 at 7:38

answered Jan 23, 2017 at 18:25

Only need to execute it in query editor
ALTER AUTHORIZATION ON DATABASE::YourDatabase TO [domainaccount];

The real problem is that the default owner(dbo) doesn’t have a login mapped to it at all.As I tried to map the sa login to the database owner I received another error stating «User,group, or role ‘dbo’ already exists…».However if you try this code it will actually works :

EXEC sp_dbcmptlevel ‘yourDB’, ’90’;

go

ALTER AUTHORIZATION ON DATABASE::yourDB TO «yourLogin»

go

use [yourDB]

go

EXECUTE AS USER = N’dbo’ REVERT

go

answered Apr 17, 2013 at 9:18

answered Apr 26, 2015 at 8:38