SQL Server用户映射问题 [英] SQL Server User Mapping Issue

问题描述

基本上，每当我创建一个新数据库时，用户就映射到dbo而不是实际的登录属性，如下图所示.fsdgsgsg是一个新数据库，但职员和仓库是从其他位置连接的数据库.
http://imageshack.us/photo/my-images/854/error1q.png


当我尝试将其更改为MASTER \ Milton时，出现此错误.它搞砸了我的ADO.Net并阻止了我对其进行访问.有人知道如何解决这个问题吗?

http://imageshack.us/photo/my-images/267/error2e.png

Hi,

Basically whenever I create a new database the user maps to dbo rather than the actual login property as illustrated below fsdgsgsg is a new one but staff and warehouse are attached databases from elsewhere.
http://imageshack.us/photo/my-images/854/error1q.png


When I try to change it to MASTER\Milton it comes up with this error. Its screwing my ADO.Net up and stopping me from accessing it. Anyone know how to fix this?

http://imageshack.us/photo/my-images/267/error2e.png

推荐答案

dbo 实际上不是传统意义上的用户. dbo表示数据库所有者.无法重命名此用户"，因为它是伪用户.

如果需要，可以使用其他凭据在数据库内部创建对象，它们将成为对象的所有者(表，视图，过程等).

什么是实际的问题/代码，调用数据库时不起作用?

dbo isn''t actually a user as in traditional sense. dbo means the database owner. This ''user'' cannot be renamed since it''s a pseudo user.

If you want you can create objects inside the database with other credentials and they will become the owners of the objects (tables, view, procedures and so on).

What is the actual problem/code what isn''t working when calling the database?

这篇关于SQL Server用户映射问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！