web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / How to connect SQL Ser...
Copilot Studio
Suggested Answer

How to connect SQL Server as knowledge to my Copilot studio agent

(1) ShareShare
ReportReport
Posted on by N962908 30
I don't see any connector available when i try to connect SQL Server . i have tested my SQL server using the gateway in Power automate, SQL server connection is working fine.
 
Only thing i need is to connect SQL Server as knowledge and play with it? Any Link/Article to follow
 
Thanks
Categories:
Autonomous agents
Calling actions from Copilot Studio
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 679 on at
    Hi,

    Do you have an on-premise SQL server or are you using Azure SQL? Both are supported, but the on-premise version should be SQL server 2008 or higher. There are some more limitation. You can read more here: Azure SQL and Microsoft SQL Server Microsoft 365 Copilot connectors - Microsoft 365 Copilot connectors | Microsoft Learn
     
    In case the SQL server connector is not available, check if there are policies set to not allow using the connector, e.g. DLP or Advanced Connector Policies.
  • Suggested answer
    Vish WR Profile Picture
    Vish WR 3,748 on at
    Hi Andre 
    Not sure if this can help as i have not tried yet i dont have a SQL server to test
    .
    i would recommend to check check out this link for details 
    https://learn.microsoft.com/en-us/microsoft-copilot-studio/knowledge-copilot-connectors

    You may need to add connector in admin center to SQL connector  for copilot studio . attaching the screenshot for your reference

    If my answer helped you, please give me a thumbs up (👍). 
    If solve your question please mark as answer ✔️. This is help the community.
    If you want talk with me just tag me @wrvishnu 
     
    ScreenShots.docx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 277

#2
11manish Profile Picture

11manish 206

#3
sannavajjala87 Profile Picture

sannavajjala87 156 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt

Product updates

Microsoft Power Platform Community release plans