Creating Azure SQL Database
Note: Make sure Collation Settings are SQL_Latin1_General_CP1_CS_AS
For security reasons, we have the SQL Azure Database with Auditing & Threat detection along with Transparent Data Encryption.
Keep all the defaults in here.
Note running as a specific user needs logon as service privilage
Same Applies for the TeamCity Agent Configuration
The data directory needs to exists before you copy the sqljdbc driver to connect with azure sql server database. Hit refresh the JDBC drivers
Now we have the TeamCity Server running in Azure VM with Azure SQL database.
Thanks for reading the article !!