Unanswered

Copilot agent connected to on-prem SQL server via MS Graph Connector giving SQL queries as answers

(1) Share

Report

Posted on by ZA-04031847-0

After Integration of MS SQL server(New) connector with on-premises MS SQL server, I am receiving unexpected answers when asking questions from a Copilot agent. Copilot is returning SQL queries that will provide the answers instead of returning the actual answers from the database. What do I need to do to have the Copilot agent use the data in the SQL database to answer the questions?

Categories:

General topics

SQL2.png

SQL.png

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Did you set up the required Enterprise Gateway?

Was this reply helpful? Yes No
ZA-04031847-0 8 on at

Like (0)

Report

I have installed MS Graph Connector agent on my PC which is in the same network as the on-prem SQL server. I am using this connector agent with the MS Graph Connector (Microsoft SQL Server) and confirmed access to the SQL data. The connector is also able to index the SQL data successfully. I have added this connector as a knowledge source for my Copilot agent in Copilot Studio. However, the Copilot agent does not seem to be accessing the SQL data to answer questions.

Was this reply helpful? Yes No