cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Can't connect to On-Premise SQL Server (Licence error?)

Hi!

 

I'm trying to connect Power Apps to our on-premise SQL-database. I have a data gateway installed and it is working great with Power BI, for example. I can see the gateway in Power Apps, but when I try to create a new connection, I get this error message:

 

"Your licence(s) doesn't support the use of gateways. To use this feature, start a trial" (screenshot attached)

 

I can't see how that can be, since I have a Microsoft 365 E5 licence. That should pretty much cover everything.

 

The info I type in, when trying to create the connection:

 

Login type: SQL Server Login

 

Server:

OurServer\MSSQLSERVER

 

Database:

OurDataBaseName

 

Username:

SQL-user

 

Password:

SQL-user password

 

Gateway:

The gateway I installed

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Can't connect to On-Premise SQL Server (Licence error?)

Hi @ilied 

Unfortunately, an E5 license doesn't cover the use of on-premise SQL server.  This is to is why you see the trial message.

The on-premises gateway is a premium connector and therefore, it requires a per app or user plan.

A per app plan starts at $10/user/month.

There are more details here.

https://powerapps.microsoft.com/en-us/pricing/ 

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: Can't connect to On-Premise SQL Server (Licence error?)

Hi @ilied 

Unfortunately, an E5 license doesn't cover the use of on-premise SQL server.  This is to is why you see the trial message.

The on-premises gateway is a premium connector and therefore, it requires a per app or user plan.

A per app plan starts at $10/user/month.

There are more details here.

https://powerapps.microsoft.com/en-us/pricing/ 

View solution in original post

Highlighted
Frequent Visitor

Re: Can't connect to On-Premise SQL Server (Licence error?)

Thank you, i'll look into this.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,016)