DB connectivity issues after installing the AIP Scanner tool

Question

"Get-AIPScannerConfiguration : Failed to access scanner database. Verify the database is up and running and can be
accessed by scanner service account and by the currently logged in user that executes the command.
At line:1 char:1

• Get-AIPScannerConfiguration
• ~~~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : NotSpecified: (:) [Get-AIPScannerConfiguration], PowershellException
• FullyQualifiedErrorId : Microsoft.InformationProtection.Powershell.AIP.Commandlets.Scanner.GetAIPScannerConfigurationCommand"

Answer 1

@Pao-6748

Thank you for reaching out to us. From the error message it looks like AIP scanner unable to connect to the database.

Wanted to check was this working before ? Did you make any changes to the database with respect to permissions.

Make sure that the service account being used to run scanner processes has required permissions to access the database ?

Execute this command Start-AIPScannerDiagnostics -onbehalf $scanner_account_creds - Use the credentials which were used to setup the AIP scanner initially,

Let me know if you have any questions.

Please remember to "Accept Answer" if answer helped, so that others in the community facing similar issues can easily find the solution.

Answer 2

Here's what I believe fixed it - Login in Windows server as the AIPScanner service. Ensure that AIPScanner service is a local admin. Ensure that AIPScanner is dbowner in master database. Whenever you make changes,wait about 15 minutes before testing. I was testing immediately after I make changes to the scanner and it confuse me because I get failed result. If I wait a bit every after change, it started working and givine me more accurate result.