How to create custom user login for Azure SQL Database
When I was trying to create second Azure SQL database on the same shared SQL Server I stuck for a few minutes with a problem that Azure didn’t allow me to create new user (credentials) for this new DB. It turns out that Azure UI does not allow creating users for different databases on the same server.
However, it is logically to have separate credentials for apps per database. Fortunately, we can create users and logins with T-SQL. Here is solution.
Read more...