Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Switching SQL Authentication Method - Errors

(0) ShareShare
ReportReport
Posted on by

We recently moved away from SQL Server Authentication to a new security method for our SQL Database where we only use Azure Active Directory. As I try to change the authentication method for probably 50+ SQL actions in our flow library I get this error. Looking at the code of the action it looks like the path key in the JSON is missing the SQL Server and Database (although it still has the table name). This is extremely frustrating as the only way I can think to fix this issue is to rebuild every single SQL action in my flows when all I am doing is trying to switch the authentication method to something more secure. 

 

I've tried downloading the zip file and editing the JSON but it uploads with error no matter how careful I am. 

 

 

2022-11-11 15_04_35-Edit your flow _ Power Automate and 14 more pages - Work - Microsoft​ Edge.png

 


Example of code error after switching from the SQL Server Authentication connector to the Azure AD Connection method.

"path":"/datasets/default/tables/@{encodeURIComponent(encodeURIComponent('[dbo].[xxx]'))}/items"
What would work if I recreated the SQL Action with V2
/v2/datasets/@{encodeURIComponent(encodeURIComponent('xxxxxserverendpoint'))},@{encodeURIComponent(encodeURIComponent('databasename'))}/tables/@{encodeURIComponent(encodeURIComponent('[dbo].[xxxx]'))}/items
 
any suggestions or ideas would be helpful. This migration from SQL Server Auth to Azure AD Password + conditional access has been a nightmare on the Power Automate flow and I wish Microsoft would make this kind of thing easier. 

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,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics