Igor Kitsula - Developer

A Programmer Reference


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...