Purview scanner database connectivity issue

Rime Razgallah 0 Reputation points
2024-03-31T18:13:38.64+00:00

after multiple reinstalls and startovers I am still facing the same error :start-AIPscan : 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.

The currently logged in account is the the scanner account (hybrid) the is local admin on the server, sys_admin and db_owner on SL server I can log in to the instance and modify the database, what am I missing?

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,171 questions
{count} votes

2 answers

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 89,571 Reputation points Microsoft Employee
    2024-04-01T07:25:21.6066667+00:00

    @Rime Razgallah - Thanks for the question and using MS Q&A platform.

    It seems like you are facing an issue with the Microsoft Purview scanner database connectivity. The error message suggests that the scanner service account and the currently logged-in user do not have access to the scanner database.

    To troubleshoot this issue, you can try the following steps:

    • Verify that the scanner database is up and running. You can do this by connecting to the SQL Server instance where the scanner database is hosted and checking the status of the database.
    • Verify that the scanner service account has the necessary permissions to access the scanner database. The scanner service account should have at least db_datareader and db_datawriter roles on the scanner database.
    • Verify that the currently logged-in user has the necessary permissions to access the scanner database. The user should have at least db_datareader and db_datawriter roles on the scanner database.
    • Check if there are any firewall rules that are blocking the connection to the scanner database. You can try temporarily disabling the firewall to see if it resolves the issue.
    • Check if there are any antivirus or security software that is blocking the connection to the scanner database. You can try temporarily disabling the antivirus or security software to see if it resolves the issue.

    If none of the above steps resolve the issue, please provide more information about your environment and the steps you have taken so far to troubleshoot the issue. Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments No comments

  2. David Broggy 5,811 Reputation points MVP
    2024-04-01T18:38:00.6966667+00:00

    Hi Rime,

    Are you sure you installed the right scanner agent?

    Here are some tips, below:

    https://learn.microsoft.com/en-us/purview/deploy-scanner
    
    The only app required on the Windows Server is the AIP Unified Labeling Client. 
    This will install the cmdlets used for the PowerShell section. 
    You can find it at this link: Download Azure Information Protection from Official Microsoft Download Center
    
    Install and configure the Microsoft Purview Information Protection scanner | Microsoft Learn
    
    MPIP - Microsoft Purview Information Protection - old name for the Purview Unified Labeling Agent. (or AIP scanner) The Purview agent sits on top of the MPIP service..
    
    https://learn.microsoft.com/en-us/azure/information-protection/rms-client/use-client
    
    
    
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.