Create-VmUserRole

Create-VmUserRole.sql

/** Run on Master DB **/

/** Change variables to name of VM needing Access to Azure DB **/
DECLARE @vmName1 NVARCHAR(20) = 'AzDO-01'

/** Declare query variables **/
DECLARE @query1 NVARCHAR(MAX),
        @query2 NVARCHAR(MAX)

/** Update @vmName1 **/
SET @query1 = CONCAT('CREATE USER [', @vmName1, '] FROM EXTERNAL PROVIDER')
SET @query2 = CONCAT('ALTER ROLE [dbmanager] ADD MEMBER [', @vmName1, ']')

/** Execute query variables **/
EXEC sp_executesql @query1
EXEC sp_executesql @query2

/**
	CREATE USER [azdo-app-01] FROM EXTERNAL PROVIDER
	ALTER ROLE [dbmanager] ADD MEMBER [azdo-app-01]
**/