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
Your Invited to Keeping It Real with the Power Platform
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 12
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... 544 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 1,005 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
Your Invited to Keeping It Real with the Power Platform

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 618

#2
Haque Profile Picture

Haque 147

#3
Vish WR Profile Picture

Vish WR 140

Last 30 days Overall leaderboard

Featured topics

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

Product updates

Microsoft Power Platform Community release plans