- From Visual Studio, Connect to the Azure SQL Database using Sql Server Object Explorer
- New Query…
CREATE LOGIN [biz-crm] WITH PASSWORD ='StrongPasswordWithDigitsAndSymbols0192837493~@()&%£*($&)$*£(';
CREATE USER [biz-crm] FROM LOGIN [biz-crm];
ALTER ROLE db_datareader ADD MEMBER [biz-crm];
ALTER ROLE db_datawriter ADD MEMBER [biz-crm];