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

Notifications

Announcements

Community site session details

Community site session details

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

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

Categories:
I have the same question (0)
  • timl Profile Picture
    36,383 Super User 2025 Season 2 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,383 Super User 2025 Season 2 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

  • 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard