cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Digvijay
Advocate II
Advocate II

Sql Server Connector not working in Power Automate

Hello Team,

 

From Last 2-3 days i'm not able to create a new flow with Sql Server. It's not allowing me to create any actions nor able to edit my flows.

 

It's working with other colleagues only not working with mine system.

 

 

3 REPLIES 3
rimatos
Microsoft
Microsoft

Hi @Digvijay,

 

Do you have any screenshot of what error you are prompted when attempting to use the SQL server? Could you also verify if you are able to see the SQL connection in the Data -> Connections tab on the left side of the Flow main page?

 


Additionally, make sure that you are using a user with the correct licenses assigned, as the SQL connector is currently a Premium connector, and as such it will require a Premium License (e.g. Flow per user Plan) .

 

 

Hope this helps, and let me know what you could find.

 

Regards,

Ricardo

Hi Ricardo,

 

I'm able to see the sql connections in Data>Connectons tab.

 

I already have below plans in PowerApps.

PowerApps Plan 2 

PowerApps for Office 365

 

Should i need separate plans for Flows Also.

Hi @Digvijay,

 

I believe you do. You can verify this by getting some trial licenses for the Flow per user plan and assigning them to yourself. You can get the trial from the office 365 admin center.

 

image.png

 

 

After that you should be able to use the SQL connector.

 

Let me know if this was useful!

 

Regards,

Ricardo

Helpful resources

Announcements
March Update

Join Stephen Siciliano and the Power Automate team at MBAS

Make sure you are registered #MSBizAppsSummit #CommunityRocks

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (60,494)