我不能用我在SQL Azure中创建了一个用户登录 [英] I can't login with a user I created in sql azure

问题描述

我创建了一个用户名和在SQL Azure中用户，但我不能登录？
我可以用管理员帐户只能连接...

I created a login and a user in sql azure but i'm not able to login... I can connect only with the administrator account...

如何登录与我创建的用户？

How do I login with the user I created?

推荐答案

我一直在这个奋斗过了，经过一番研究，似乎只有LOGINS可以登录。一个用户（在特定数据库中创建的，从登录）仅仅是一个人物在访问特定的数据库时登录假设。

I've been struggling with this too, and after some research it appears that only LOGINS can login. A User (created in a specific database, from a login) is only a "persona" that a login assumes when accessing that particular database.

所以，同样，你无法登录的用户，只能用登录。如果你的目的是要创造某种方式到特定的数据库访问限制，那么你需要做一些工作：目前，我在看下面的文章：

So, again, you can't login as a User, only with a Login. If your intention is to somehow create restricted access to a specific database then you need to do some work: I'm currently looking at the following article:

<一个href=\"http://blogs.msdn.com/b/benjguin/archive/2012/01/21/sql-azure-create-a-login-that-has-only-access-to-one-database-sql-azure-cr-233-er-un-login-qui-n-a-acc-232-s-qu-224-une-base-de-donn-233-es.aspx\">http://blogs.msdn.com/b/benjguin/archive/2012/01/21/sql-azure-create-a-login-that-has-only-access-to-one-database-sql-azure-cr-233-er-un-login-qui-n-a-acc-232-s-qu-224-une-base-de-donn-233-es.aspx

心连心。

这篇关于我不能用我在SQL Azure中创建了一个用户登录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！