Unanswered

Copilot Studio: Microsoft SQL server (New ) unavailable as knowledge source

(1) Share

Report

Posted on by ZA-04031847-0

While creating a Copilot agent in Copilot Studio, I am trying to integrate on-premises Microsoft SQL server as knowledge source. In Add knowledge section there are two types (Featured and Advanced). In Advanced Section there are only a few connectors which can be used while others are unavailable. Why are some of the items unavailable? How can I make them available for use with the Copilot agent? I am specifically interested in Microsoft SQL server(New) connector.

Categories:

General topics

Snap1.png

Snap2.png

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

You will need to use a gateway for an on-prem SQL server source.

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

Like (0)

Report

Hello Ibnedlin.

I have installed MS Graph Connector. It is now showing available in copilot studio. Now, I am able now able to add "Microsoft SQL server(New)" connector in "Add knowledge section" of copilot studio but it is is not giving responses in copilot studio from giving database. In short, i am not able to search and retrieve data from my On-Premises Database while using it as a connector in "Add knowledge section". While It is showing preview of SQL Database in admin.microsoft.com while configuring Connector.

1 people found this reply helpful.

Was this reply helpful? Yes No