Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building 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

Categories:
  • Giovanni1 Profile Picture
    on at
    Re: connection with sql

    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

  • Giovanni1 Profile Picture
    on at
    Re: connection with sql

    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

  • Verified answer
    timl Profile Picture
    34,939 Super User 2025 Season 1 on at
    Re: connection with sql

    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
    Re: connection with sql

    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.

  • timl Profile Picture
    34,939 Super User 2025 Season 1 on at
    Re: connection with sql

    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?

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard