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

Question

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

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.

Answer 1

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

On the firewall settings of the Azure SQL database:

Please allow Azure services to access the database.

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

Hope this helps.

Answer 2

@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.