The MS Doc I'm using for these SQL commands is https://docs.microsoft.com/en-us/sql/t-sql/statements/create-login-transact-sql?view=azuresqldb-mi-current
I really appreciate your replying but there is a disconnect somewhere and I'm sure its because of my lack of knowledge with Azure. I know SQL Server very well for DCL, DDL & DML but I'm VERY new to Azure.
The Azure setup was done by our IT guys and I've been tasked with taking care of things like getting's users in place to access the DB. We have an Azure SQL Database and not a Managed Instance which if I understand correctly means somethings aren't supported.
The end goal is to allow for a Microsoft Access based front end to connect to a SQL Database. Until now this has all been local within our on prem domain and each user has connected via Windows Authentication.
NOTE: I don't deal with the MS Access app I just take care of the SQL Side.
Currently I can get connected to the Azure SQL DB with SSMS 2018 using Azure Active Directory - Universal with MFA. When I try to create a login for a local Azure AD account using the DCL sown below I get the error message Msg 102, Level 15, State 48, Line 6 Incorrect syntax near 'PROVIDER'. If I read this right its because we have an Azure SQL DB and not a managed instance.
CREATE LOGIN [firstname.lastname@example.org] FROM EXTERNAL PROVIDER
After this I tried and was bale to successfully execute the same command but for CREATE USER. I'm hoping that means that we can replicate in Azure what we've been doing on prem in our domain with this thing.
CREATE USER [email@example.com] FROM EXTERNAL PROVIDER
Just say No to Facebook!