Until recently, I didn’t realize that SQL Azure allows you to create new logins, users, and roles. They don’t expose this functionality through the UI, it all has to be done through T-SQL commands.
- Run this when connected to master:
CREATE LOGIN MyReportingUser WITH PASSWORD='MyP@assWord123'
- Then connect to the database you want to add the user to and run this:
CREATE USER MyReportingUser FROM LOGIN MyReportingUser
- You can then grant them a role:
EXEC sp_addrolemember 'db_datareader', 'MyReportingUser'
You can then connect to your SQL Azure database using that new login.