Hello,
I have create an AI agent to help retrieve information from Azure SQL database, of course it is a structure database with rows and columns.
The issue is: I prompt the Agent and it respond properly at times but it mostly returns response like 'The retrieved documents do not contain specific information...', whereas it sometimes respond with the correct information as contained in the database.
I connected using the SQL Authentication type during initial connection and I have also used both SQL authentication and the Microsoft Entra ID integrated authentication type at first chat.
I have used both generative AI orchestration and classic orchestration.
Kindly share any insight on how to solve this issue. Thanks in advance.
