cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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

Highlighted

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.

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Users online (8,789)