如何登录dbo用户，？ [英] How to login to dbo user, ?

问题描述

我正在使用sqlserver 2014ms

i在我的系统中有两个系统当前用户是'dbo'..一切都很好，

在我的其他系统中当前用户是' guest'...现在我无法创建或访问该系统的数据库..



显示此消息

I am using sqlserver 2014ms
i have two systems in my system current user is 'dbo'.. everything is fine,
in my other system current user is 'guest'... now i cant create or access the database of that system ..

showing this message

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

Property Collation is not available for Database '[TESTDB]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Collation&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

请帮帮我..我想创建和访问现有的数据库



我尝试过：



i试图改变服务器角色..检查权限我尝试了很多选项我cudnt找到任何解决方案

Help me please .. i want create and access access the existing db

What I have tried:

i tried to change server roles .. checked permission i tried lot of option i cudnt find any solution

推荐答案

你可以不要将您的权限更改为访客用户 - 您需要以具有足够权限的用户身份登录。如果你在数据库服务器上没有这样的登录帐户，那可能是因为你不想要它！ ：笑：这是（毕竟）需要登录的全部原因，如果你可以改变你的权限，那么任何人都可以...



与DB管理员交谈负责服务器，看看他是否会设置一个允许你使用该特定数据库的帐户。

You can't change your permissions as a "guest" user - you need to log in as a user who has sufficient permissions. And if you don't have such a login account on a DB server, that's probably because you aren't wanted on it! :laugh: That is (after all) the whole reason for requiring logins, and if you could change your permissions so could anyone...

Talk to the DB admin responsible for the server, and see if he will set you up an account that allows you to use that specific database.

这篇关于如何登录dbo用户，？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！