Forum Discussion
AIP UL Scanner database schema issue (DB pre-created)
Hello everyone,
Trying to install and configure the AIP UL Scanner in preview for a client. However, because of internal security policies, it was not possible to let the Install-AIPScanner cmdlet create the SQL database itself. We had to ask the DBA to create the AIP Scanner DB prior to the Scanner installation.
We followed the instructions found here:
Then I followed the standard AIP Scanner installation and configurations steps. Service was installed (with a SQL error that was expected since it is documented), we also completed the Azure App Registration configuration and ran the Set-AIPAuthentication cmdlet with success.
After starting the AIP scanner service, I was expecting the Scanner to show up in the Azure AIP Scanner Nodes list. It did not.
I then ran Start-AIPScan locally hoping that the service would report itseft to Azure but received the following error:
>> TerminatingError(Start-AIPScan): "Invalid database schema. Run the Update-AIPScanner cmdlet to upgrade your database."
Start-AIPScan : Invalid database schema. Run the Update-AIPScanner cmdlet to upgrade your database.
This was a surprise to me but since this approach (pre-creating the SQL DB) is not so well documented (especially for the UL client in preview), I thought I should try to run the Update-AIPScanner cmdlet and see how it goes from there. The result was not better. Here's the error I got:
>> TerminatingError(Update-AIPScanner): "An error occurred during deployment plan generation. Deployment cannot continue."
Update-AIPScanner : An error occurred during deployment plan generation. Deployment cannot continue.
I did search the web for these errors and cannot find anything at all.
Would anybody have an idea of what I'm doing wrong? Anybody that pre-created the SQL DB before running the AIPScanner UL client installation?
Thanks.
- DianaSCarneiroCopper ContributorHi,
I am experiencing the same issue.
Have any of you found a solution?
Best Regards - folucianMicrosoftDid you make sure that the installer account' you were using was a Local Administrator on the scanner server and has the Sysadmin role on the SQL server where the scanner database will be hosted?
- FahadAhmedBrass Contributorhaving the same issue, still looking for resolution.
- mykhanCopper ContributorDid this issue resolved? I'm getting the same error.
- FahadAhmedBrass Contributor