Ways to set the authentication credentials
There are two ways:
- Provide the Windows user credentials in the AppMon settings
- Via single sign on (SSO) automatically with the credentials of the user account under that the AppMon server services run.
Enable Windows Authentication for SQL Server
The following debug flags need to be added to the AppMon server:
com.dynatrace.diagnostics.SQLSERVERUSENTLMV2 = true
com.dynatrace.diagnostics.SQLSERVERDOMAIN = <domain>
as described in this KB article: Setting AppMon Server Debug Flags
<domain> with your Windows domain name, eg. yourdomain.local or the shorter NETBIOS representation.
Credentials in Dynatrace
After a restart of the dynaTrace Server service it should be possible to set the Windows Authentication credentials in the Performance Warehouse dialog and successfully connect.
Credentials via Single Sign On (SSO)
Beside the two above mentioned debug flags/properties, additionally the following one needs to be added to allow empty credentials in the Performance Warehouse settings dialog:
com.dynatrace.diagnostics.repository.skipEmptyPWHPasswordCheck = true
To enable SSO, the by the AppMon server used JDBC driver needs an additional binary, which is available for free as a separate download from the project page of jTDS. Therefore download the latest distribution package and extract the native Windows binary called
ntlmauth.dll, which is located in the platform directory which matches your configuration (likely
\x64\SSO, since AppMon is only supported on x64 Windows). According to the jTDS single sign on documentation (
README.SSO), the library needs to placed in a location that is set in the PATH environment setting. Successful testing was performed with using %WINDIR% (normally
After a restart of the AppMon server service, the Performance Warehouse connection can also be established with empty credentials, if the setup is correct (AppMon server services are running with the user that is configured as DBO on the SQL server instance running the Performance Warehouse database).