Symptoms

Assets > SQL DATABASES do not show any SQL Databases after discover is run manually several times. In SQL Server, the ADM log shows (ADM log: C:\Program Files\DPSAPPS\MSAPPAGENT\ADM Agent\logs): ... ( Disposition: form-data; name="results"; filename="C:\\Windows\\TEMP\\ecdmruncmd775979743" Content-Type: application/octet-stream { "response": { "APIVersion": "2.2", "applicationInstances": [] }, "errors": [ { "type": "systemErr", "text": "General exception when detecting AAG information for SQL Server '<SQL SERVER name>'.\n" } ] }

Cause

PowerProtect Database Manager Console fails to connect to the SQL server using the LocalSystem Account.

Resolution

Procedure: On the Windows SQL Server, go to services.msc.Select ADM agent.Right click and select Properties.Click Log On.Click This account and input a Windows user with access to the SQL server. Note: Sometimes, the software works better if the Windows user is a Domain Admin as well. If possible, ensure that the Windows user has access to SQL Server and is a Domain Admin as well. Restart the service.

Support Cases