Simple Steps : Install TeamCity 10 with Azure SQL Database (V12)

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 !!