Tech Tip: SQL Server 5.7 Connection Troubleshooting

Question:

Is there a reason why on collector log I see a failure collection on SQL “master” database ?

Answer:

Make sure you have configured the SQL Server monitoring as per the DPA 5.7 Administration Guide:

Collector requirements

• The Collector needs to be able to connect to the SQL Server "master" database in order to gather the data required. The Collector can either:
• Use "SQL Server Authentication" using the credentials of the request (if set).
• Use "SQL Server Authentication" using the credentials against an explicit "master" database in the list of databases to be monitored (if set)
• If these are not set, the Collector uses "Windows Authentication" using the logon ID of the dpa_collector process.

If none of these are sufficient to connect to the "master" database, the request will gather no data.