The documentation page of SQL Azure connections can be found here.
Minimum account requirements:
SQL Server on Azure connection accounts are treated the same as SQL Authentication in Spotlight. When using a SQL authentication account, please first create the login account then map a database user to the login account. Lastly, assign sufficient database level permission. Use the below link as a reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins
An example of a verified SQL authentication account:
Create account Login1 map with SoSSESQLAzure database user User1 by using the following commands:
1. -- In master database run below command
CREATE LOGIN Login1 WITH PASSWORD = '< strong_password>';
2. -- In SoSSESQLAzure database run below command
CREATE USER User1 FROM LOGIN Login1
ALTER ROLE db_owner ADD MEMBER User1;
