I'm having a similar issue to this question (https://dba.stackexchange.com/posts/123094/edit)! I have followed the following article: https://azure.microsoft.com/en-gb/documentation/articles/sql-database-manage-logins/ and just cannot get it to fully work.
-- first, connect to the master database
CREATE LOGIN login1 WITH password='password';
-- Establish a new connection to the database
CREATE USER login1user FROM LOGIN login1; GRANT CONNECT TO login1user EXEC sp_addrolemember 'db_datareader', 'login1user '; EXEC sp_addrolemember 'db_datawriter', 'login1user '; EXEC sp_addrolemember 'db_ddladmin', 'login1user ';
The issue is, I cannot connect to my database with login1user. I have to use the login1 details, which isn't really what I was expecting to happen. I would be happy having the names the same, except for bullet point three in the remarks section of this article (https://msdn.microsoft.com/library/ff929188.aspx), suggests that this isn't best practise.
Any help appreciated!