@JacobEllis-2694
Thank you for reaching out to us. As I understand you are configuring AIP scanner configuration during the process encountering database errors.
Would like to understand is this a new setup ?
Have you used an account with Sysadmin role to install the scanner - Sysadmin role enables the installation process to automatically create the scanner configuration database and grant the required db_owner role to the service account that runs the scanner.
Accounts and Permissions - https://techcommunity.microsoft.com/t5/security-compliance-and-identity/best-practices-for-deploying-and-using-the-aip-ul-scanner/ba-p/1878168#:~:text=mileage%20might%20vary.-,Accounts%20and%20permissions,-Depending%20on%20your
Please help me with the scanner logs
If you log on to the server as the scanner account, use option one. Otherwise use the second option.
- Log into the AIP Scanner server and navigate to %localappdata%\Microsoft\MSIP. Zip up the MSIP directory including subdirectories.
- Navigate to C:\Users, find the AIP Scanner account directory, and zip the C:\username\localappdata\Microsoft\MSIP directory, including subdirectories.
Also did you perform SQL connectivity test, you can simply perform an UDL test.
Let me know if you have any further questions.