web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / connection with sql
Power Apps
Answered

connection with sql

(0) ShareShare
ReportReport
Posted on by

Hi, I have a problem connecting to sql server, on a new server. If I try an odbc connection from outside it works fine. It gives me a message: an error has occurred, try again later. Could you give me some advice on what it could be? Thanks in advance

Immagine1.jpg
Categories:
I have the same question (0)
  • timl Profile Picture
    36,815 Super User 2026 Season 1 on at

    Hi @Giovanni1 

    It looks like you're trying to connect to an on-premise instance of SQL Express. 

    Have you installed the on-premise gateway?

    When you say that an ODBC works from outside, can you confirm what you mean by outside? Do you mean across the internet, or do you mean from another machine on your local network?

  • Giovanni1 Profile Picture
    on at

    Yes, I am trying to connect to a local SQL Express instance. Have you installed the gateway on site? No, without a gataway.

    When you say that an ODBC works from the outside, can you confirm what you mean by external? Do you mean over the Internet or from another machine on your local network? Through the Internet.

    My server, on which I am trying to initiate the connection, is a cloud server. Also, if from this server, I try to create a sql connection on another sql server, this is created regularly.

  • Verified answer
    timl Profile Picture
    36,815 Super User 2026 Season 1 on at

    Hi @Giovanni1 

    You would need to install the on-premise gateway on the cloud server where you installed SQL Express.

    The only version of SQL Server that you can connect to without a gateway is SQL Azure.

    Once you install the gateway, you should be able to make a connection.

     

  • Giovanni1 Profile Picture
    on at

    I tried to install a gateway, but even here at the end of the installation, it gives me an error message and does not create the gateway

    Immagine2.jpg
  • Giovanni1 Profile Picture
    on at

    Non è stato possibile creare il gateway. Riprovare.
    Response status code does not indicate success: 500 (Internal Server Error)
    Request Id: 767872d1-6b64-4041-ab94-dfc1c44433b4
    Timestamp: 28/08/2020 10:07:00 +00:00
    ErrorCode: ADGraphGroupOperationFailed

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 914

#2
11manish Profile Picture

11manish 627

#3
Valantis Profile Picture

Valantis 598

Last 30 days Overall leaderboard