How can I adjust Copilot Studio’s AI Agent to directly retrieve data from an Azure SQL DB rather than producing a SQL query? I encounter a 400 ConnectorRequestFailure error.
hey, check if your agent settings properly point to your azure sql db; i had a similar issue due to a typo in my connection strin which caused the error. updating that fixed things for me.
Considering similar issues I encountered recently, I found that the ConnectorRequestFailure error is usually due to misconfiguration in the agent settings. The AI Agent is often configured to generate a SQL query rather than directly retrieving data, so an adjustment in the configuration parameters is necessary. Reviewing authentication credentials, connection strings, and ensuring the correct API endpoints for direct data queries have resolved the error in my experience. Making these adjustments in the Copilot Studio interface allowed the agent to operate in the intended mode.