Before you Begin

To connect to the Azure SQL database using a Windows authenticated account, perform the following:

  • Select Windows Authentication checkbox when creating the collector using "Create New Collector" dialog.

    Note: Do not specify the username and password when updating database connection details.
  • Specify the path to the Database Agent authentication library as follows:

    Version Details Path
    Windows 64-bit
    java -Djava.library.path="C:\dbagent_install_dir\auth\x64" -jar db-agent.jar
    Windows 32-bit
    java -Djava.library.path="C:\dbagent_install_dir\auth\x86" -jar db-agent.jar
  • Ensure that the Windows account user has appropriate privileges to authenticate the database server and can start the database agent.
  • Change the logon credentials of the service to the Windows account with SQL Server access, if using a Windows service to run the Database Agent.

To connect to the Azure SQL database using Azure Active Directory Password, add the following property while configuring the Azure SQL database collector:

  • Property: authentication
  • Value: ActiveDirectoryPassword

You can add the property using one of the following fields:

  • Connection Details > Custom JDBC Connection String
  • Advanced Options > Connection Properties