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.

Installing TeamCity

Keep all the defaults in here.

Note running as a specific user needs logon as service privilage

Same Applies for the TeamCity Agent Configuration

Configuring TeamCity

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.