blocks|key|3282653|text|您应该考虑数据库所有权的SQL身份验证帐户；这样您就不必担心帐户来来去去、数据库或实例移动到不同的服务器，以及您的下一台PC名称更改。我有几个系统，我们使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3282654|ALTER+AUTHORIZATION+ON+DATABASE::Ariha+TO+[sa];|code-block|syntax|javascript|3282655|或者，如果要将所有者更改为该本地管理员帐户，则应为：|3282656|ALTER+AUTHORIZATION+ON+DATABASE::Ariha+TO+[DevPC\Administrator];|3282657|因为将机器重命名为DevPC消除了以前名为WIN-ND...\Administrator的本地帐户，这也使数据库的当前所有者无效。|offset|length|style|CODE|3282658|如果SELECT+@@SERVERNAME;不准确(应该是DevPC)，那么为了确保您的服务器重命名已在SQL+Server中生效，您可能还需要发出以下命令：|3282659|EXEC+sys.sp_dropserver+@server+=+N'old+server+name';
GO
EXEC+sys.sp_addserver+@server+=+N'DevPC',+@local+=+N'local';
GO|3282660|entityMap^0|0|0|0|0|9|5|L|N|0|2|K|T|5|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@$M|11|N|12|O|P]|$M|13|N|14|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@$M|16|N|17|O|P]|$M|18|N|19|O|P]]|9|@]|A|$]]|$1|S|3|T|5|D|7|1A|8|@]|9|@]|A|$E|F]]|$1|U|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|V|$]]

You should consider SQL authentication account for database ownership; then you don't have to worry about accounts coming and going, databases or instances moving to different servers, and your next PC name change. I have several systems where we use:
<pre><code>ALTER AUTHORIZATION ON DATABASE::Ariha TO [sa];
</code></pre>
Or if you want to change the owner to that local Administrator account, then it should be:
<pre><code>ALTER AUTHORIZATION ON DATABASE::Ariha TO [DevPC\Administrator];
</code></pre>
Because renaming the machine to <code>DevPC</code> has eliminated the local account that used to be named <code>WIN-ND...\Administrator</code> and this has also invalidated the current owner of the database.
If <code>SELECT @@SERVERNAME;</code> is not accurate (it should say <code>DevPC</code>), then in order to ensure that your server rename has taken hold within SQL Server, you may also want to issue the following:
<pre><code>EXEC sys.sp_dropserver @server = N'old server name';
GO
EXEC sys.sp_addserver @server = N'DevPC', @local = N'local';
GO
</code></pre>

blocks|key|3282714|text|在SQL+Server+Management+Studio中，执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3282715|3282716|右键单击您的数据库，选择属性，然后转到选项页|ordered-list-item|3282717|，该页位于右侧标签为"Compatibility+Level“的下拉列表中，选择"SQL+|3282718|+2005(90)”3-1。如果收到可比性错误，请选择"SQL+Server2008“。|3282719|转到”文件“页，|3282720|在所有者文本框中输入"sa”。5-1或单击省略号(...)并选择合适的所有者。|3282721|点击OK|3282722|3282723|完成此操作后，您现在将能够访问数据库关系图。|3282724|​|3282725|📷|atomic|offset|length|3282726|3282727|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/a4b1f643c74fa9d8aee500ffee6466d0.png|imageAlt^0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1B|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|1C|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1D|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|1E|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|1F|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|1G|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1I|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1J|8|@]|9|@]|A|$]]|$1|U|3|V|5|W|7|1K|8|@]|9|@$X|1L|Y|1M|1|1N]]|A|$]]|$1|Z|3|T|5|6|7|1O|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17|18|-4]]]]

In SQL Server Management Studio do the following:

<ol>
<li>Right Click on your database, choose properties</li>
<li>Go to the Options Page</li>
<li>In the Drop down at right labeled "Compatibility Level" choose "SQL Server 2005(90)"
3-1. choose "SQL Server 2008" if you receive a comparability error.</li>
<li>Go to the Files Page</li>
<li>Enter "sa" in the owner textbox.
5-1 or click on the ellipses(...) and choose a rightful owner.</li>
<li>Hit OK</li>
</ol>

after doing this, You will now be able to access the Database Diagrams.

<img src="https://i.stack.imgur.com/i9Tbb.png" alt="enter image description here">

blocks|key|320290|text|真正的问题是，默认所有者(Dbo)在all.As中没有映射到它的登录名我尝试将sa登录名映射到数据库所有者时，我收到另一个错误，指出“用户、组或角色'dbo‘已存在...”.However如果您尝试此代码，它将实际工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|320291|320292|+EXEC+sp_dbcmptlevel+'yourDB'，'90'；|blockquote|320293|320294|去|320295|将DATABASE::yourDB上的ALTER+AUTHORIZATION改为"yourLogin“|320296|320297|使用yourDB|320298|320299|以用户身份执行=N‘’dbo‘REVERT|320300|go|320301|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|W|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|11|8|@]|9|@]|A|$]]|$1|N|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|13|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|14|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|T|$]]

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 :

<blockquote>
 <blockquote>
 EXEC sp_dbcmptlevel 'yourDB', '90'; 
 
 go
 
 ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
 
 go
 
 use [yourDB]
 
 go
 
 EXECUTE AS USER = N'dbo' REVERT
 
 go
 </blockquote>
</blockquote>

blocks|key|323250|text|在owner文本框中输入"SA“而不是"sa”。这对我很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|323251|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

blocks|key|3069646|text|这为我解决了这个问题。它设置在数据库属性窗口的'files‘部分找到的所有者，并由management+studio编写脚本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3069647|USE+[your_db_name]
GO
EXEC+dbo.sp_changedbowner+@loginame+=+N'sa',+@map+=+false
GO|code-block|syntax|javascript|3069648|根据sp_changedbowner+documentation的说法，这项功能现在已被弃用。|offset|length|3069649|根据以色列的回答。Aaron的答案是这个的非弃用变体。|3069650|entityMap|0|LINK|mutability|MUTABLE|url|http://technet.microsoft.com/en-us/library/ms178630(v=sql.110).aspx^0|0|0|2|U|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@$I|X|J|Y|1|Z]]|A|$]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

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.

<pre><code>USE [your_db_name]
GO
EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
GO
</code></pre>

According to the <a href="http://technet.microsoft.com/en-us/library/ms178630(v=sql.110).aspx" rel="nofollow">sp_changedbowner documentation</a> this is deprecated now.

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

blocks|key|323260|text|我刚刚经历了这一切。我已经阅读了这个页面上的建议，以及SQL+Authority的建议(这是相同的事情)，但上面的建议都不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|323261|最后，我删除了帐户并重新创建(使用相同的用户名/密码)。就这样，所有的问题都消失了。|323262|不幸的是，这意味着我不知道哪里出了问题，所以我不能分享任何其他的东西。|323263|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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.

blocks|key|323265|text|右键单击您的数据库，然后选择属性。如果您使用的是Microsoft+SQL2008，请选择兼容性级别中的选项选择sql+200590而不是2008。然后选择文件并在所有者的文本框中写入(+sa+)。它可能会起作用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|323266|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

right click on your Database , then select properties .
select the option in compatibility levels choose sql 2005[90] instead of 2008 if you are working with Microsoft sql 2008.
then select the file and write ( sa ) in owner`s textbox.
it will work probably

blocks|key|321281|text|1.右键单击您的数据库，2.然后选择属性。3.如果您使用的是Microsoft+SQL2008，请选择兼容级别选择sql+2008100中的选项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|321282|4.然后选择文件并在所有者的文本框中写入(+sa|321283|100%25适合我。|321284|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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.

blocks|key|3069715|text|解决此问题的一种更简单的方法是右键单击数据库的名称，选择“新建查询”，键入“exec+sp_changedbowner+'sa‘”并执行查询。然后你就可以走了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3069716|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

An easier way to solve this issues would be to right click the name of your database, choose "New Query", type " exec sp_changedbowner 'sa' " and execute the query. Then you'll be good to go.

blocks|key|323289|text|我也有同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|323290|我想在家里查看我的图表，这是我当天在工作中创建的。但是因为这条消息我不能。|323291|我发现数据库的所有者是我的计算机-as期望的用户。但是由于计算机在公司的域中，而我没有连接到公司的网络，所以数据库无法解析所有者。|323292|因此，我所做的是将所有者更改为本地用户，它成功了！！|offset|length|style|BOLD|323293|希望这对某些人有帮助。|323294|可以通过右键单击数据库、属性、文件、所有者来更改用户|323295|entityMap^0|0|0|0|8|B|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@$H|V|I|W|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

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

blocks|key|3282932|text|必须以管理员身份进入，然后右键单击microsofft+sql+server+management+studio并以admin身份运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3282933|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

you must enter as administrator right click to microsofft sql server management studio and run as admin

blocks|key|3282935|text|USE+[ECMIS]
GO
EXEC+dbo.sp_changedbowner+@loginame+=+N'sa',+@map+=+false
GO|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3282936|它起作用了。|unstyled|3282937|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>USE [ECMIS]
GO
EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
GO
</code></pre>

It works.

blocks|key|321318|text|选择您的数据库-右键单击-选择属性|type|unstyled|depth|inlineStyleRanges|entityRanges|data|321319|选择页面左侧的文件|321320|在所有者框中，选择带有三个点的按钮(…)在它里面|321321|现在选择user‘sa并单击OK|321322|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Select your database - Right Click - Select Properties

Select FILE in left side of page

In the OWNER box, select button which has three dots (…) in it

Now select user ‘sa and Click OK

blocks|key|323314|text|只需要在查询编辑器中执行ALTER+AUTHORIZATION+ON+DATABASE::YourDatabase+to+domain\account；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|323315|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

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

<blockquote>
 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.
</blockquote>

Then I tried the following:

<pre><code>EXEC sp_dbcmptlevel 'Ariha', '90';
GO
ALTER AUTHORIZATION ON DATABASE::Ariha TO [WIN-NDKPHUPPNFL\Administrator]
GO
USE Ariha
GO
EXECUTE AS USER = N'dbo' REVERT
GO
</code></pre>

Next erorr pops up: 

<blockquote>
 Msg 15404, Level 16, State 11, Line 1
 Could not obtain information about
 Windows NT group/user
 'WIN-NDKPHUPPNFL\Administrator', error
 code 0x534.
</blockquote>

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?

Database Diagram Support Objects cannot be Installed ... no valid owner

身份验证

SQL Server

数据库

服务器

Windows

我尝试使用SQL Server 2008创建数据库图，但出现错误：无法安装数据库关系图支持对象，因为此数据库没有有效的所有者。若要继续，请首先使用“数据库属性”对话框的“文件”页或ALTER AUTHORIZATION语句将数据库所有者设置为有效登录，然后添加数据库关系图支持对象。然后我尝试了以下方法：EXEC sp_...

问无法安装数据库关系图支持对象...没有有效的所有者
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法安装数据库关系图支持对象...没有有效的所有者EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法安装数据库关系图支持对象...没有有效的所有者
EN