I can't login with a user I created in sql azure [closed]

Question

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?

Answer 1

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:

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

HTH.