Azure SQL Database

This guide is based on the SQL Server guide with some additional considerations for Azure SQL Database.

Configuration

Using a local SQL account

This is the configuration when using a local SQL account to connect to Azure SQL Database.

Parameter	Value
cfg.server.local.config.url	jdbc:sqlserver://<server>:<port>;databaseName=<database>;encrypt=true;authentication=SqlPassword;sendStringParametersAsUnicode=false
cfg.server.local.config.user	Your Azure SQL Database username
cfg.server.local.config.password	Your Azure SQL Database password
cfg.server.local.config.driver	com.microsoft.sqlserver.jdbc.SQLServerDriver

Here is an example of an Azure SQL URL: jdbc:sqlserver://sfiler.database.windows.net:1433;databaseName=SFiler;encrypt=true;authentication=SqlPassword;sendStringParametersAsUnicode=false

Using an Entra ID account

This configuration uses an Entra ID account and password to connect to Azure SQL Database.

Parameter	Value
cfg.server.local.config.url	jdbc:sqlserver://<server>:<port>;databaseName=<database>;encrypt=true;authentication=ActiveDirectoryPassword;domain=<domain>;sendStringParametersAsUnicode=false
cfg.server.local.config.user	Your Entra ID account
cfg.server.local.config.password	Your Entra ID password
cfg.server.local.config.driver	com.microsoft.sqlserver.jdbc.SQLServerDriver

Here is an example of an Azure SQL URL: jdbc:sqlserver://sfiler.database.windows.net:1433;databaseName=SFiler;encrypt=true;authentication=ActiveDirectoryPassword;sendStringParametersAsUnicode=false

Azure Managed Identity

This uses the Identity of the Azure Resource to connect to Azure SQL Database.

This configuration is not supported currently. Okiok is making changes to the solution to support this configuration.

Active Directory Integrated

This configuration uses the Active Directory account of the "Windows" service to connect to Azure SQL Database.

This configuration is not supported currently. Okiok is making changes to the solution to support this configuration.