How to Add Users to Your Microsoft Access Azure SQL Online Database App

[@TauseefKazi]

Thanks Sean for this very useful tutorial. My question is, is it possible to create Azure users from access using passthrough query?

[@seanmackenziedataengineering]

I'm going to say you probably can, so long as the logged in user is an admin on the Azure db.

[@TauseefKazi]

I get the following error when I tried it "User must be in the master database", How do I change the context to Master database?

[@TauseefKazi]

I found out how to do it. I created two separate queries, one connected to "Master" database to create the login, and the second connect to my database to create the user, give permissions, etc. So now I can manage the users completely from Access, no need to go to SSMS 🙂