Sql Server Connector not working in Power Automate

[Digvijay]

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.

[rimatos]

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

[Digvijay]

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.

[rimatos]

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.

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

Let me know if this was useful!

Regards,

Ricardo