Azure Percept Reference solution for Voice Control Inventory Management has errors in accessing the SQl database.

vinit sawant 11 Reputation points
2022-08-18T08:06:08.857+00:00

Azure Percept Reference solution for Voice Control Inventory Management has errors in accessing the SQL database.
Trying out the reference solution in the below link-
https://github.com/microsoft/Azure-Percept-Reference-Solutions/tree/main/voice-control-inventory-management

documentation link :
https://learn.microsoft.com/en-us/azure/azure-percept/voice-control-your-inventory-then-visualize-with-power-bi-dashboard

232259-solution-architect-1.png

Getting the following error when testing the function app at step 2->7->d. of the documentation.
Error: ****Result: Failure Exception: ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot open database "Stock" requested by the login. The login failed. (4060) (SQLDriverConnect)')****

The username and password given in the CRUD.py file are correct. Still the error.
ODBC Driver 17 is also installed.

Azure Percept
Azure Percept
A comprehensive Azure platform with added security for creating edge artificial intelligence solutions.
70 questions
Azure SQL Database
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Alberto Morillo 32,806 Reputation points MVP
    2022-08-18T10:34:57.963+00:00

    Could please try to reset the Server admin password and then update the password on the CRUD.py file accordingly?

    232404-image.png

    On the firewall settings of the Azure SQL database:

    232374-image.png

    Please allow Azure services to access the database.

    232405-image.png

    To connect to Azure SQL Database using Power BI please consider the steps provided here.

    Hope this helps.

    1 person found this answer helpful.

  2. Alberto Morillo 32,806 Reputation points MVP
    2022-08-19T12:55:29.313+00:00

    @vinit sawant About the new error:

    Error: Result: Failure Exception: AttributeError: module 'azure.functions._abc' has no attribute 'SqlRow'

    Please try the solutions provided in GitHub.