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: