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

I have the same question (0)

All responses (2)

Answers (0)

Sort by

lbendlin 8,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Did you set up the required Enterprise Gateway?

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

Like (0)

Report
Copy link

Link copied!

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