Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

SQL Connector Access / Connection Issue

(0) ShareShare
ReportReport
Posted on by 24

Hi,

 

I was able to create a new SQL connector and add the same as data source in canvas app , but if I deploy the canvas app to another environment (created a new SQL connector in target environment and shared it to all other users) getting access Issue and unable to access canvas app.

 

Please advice .

  • eric-cheng Profile Picture
    eric-cheng 5,171 on at
    Re: SQL Connector Access / Connection Issue

    Hi @MaliniSaranya ,

     

    1) Is the app deployed as a solution and is the connection added as a connection reference?

    2) What authentication mechanism is being used to connect to SQL and is it the same between environment 1 and 2?

    3) When you say the users cannot access the canvas app, is it they cannot open the app at all or they are getting errors when connecting to SQL?  Can you provide some screenshots?

    4) Is the SQL on prem or in Azure?  

     

    Thanks  

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics