cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

No longer connect to on-premise SQL Server

This just started a little while ago.

2 separate PowerApps on 2 different computers cannot connect to our on premise SQL server.

Was working fine for days and even this morning, but just now began to say "Try Again" in Web Studio while trying to refresh the data sources.

I did see that there was a support update at https://powerapps.microsoft.com/en-us/support/ and it stated that it was resolved, but whatever it was, seemed to possibly impact our apps as well.

Tried closing all browsers, clearning cache, tried multipe computers, no dice...

 Also checked under Connections under our Gateway (which says it is "Live", and it says the SQL Server is "connected".)

Any ideas?

8 REPLIES 8
Highlighted
Responsive Resident
Responsive Resident

Re: No longer connect to on-premise SQL Server

what type of gateway?

Highlighted
Helper II
Helper II

Re: No longer connect to on-premise SQL Server

Yup, i was editing my post right when you replied.

Yeah, everything seems fine, but literally on 2 different computers, 2 different projects in web studio, still can't connect to those servers.

Highlighted
Helper II
Helper II

Re: No longer connect to on-premise SQL Server

On Premise Gateway.  Says it is "Live" in status.

Highlighted
Regular Visitor

Re: No longer connect to on-premise SQL Server

There is something going on that is affecting many connections. On-Prem & Azure SQL connections seem to be affected, as well as some SharePoint connections. Hopefully MS fixes something soon.

Anonymous
Not applicable

Re: No longer connect to on-premise SQL Server

I got same error on Microsoft Flow. Flows are failing to connect to SQL Server and SharePoint Online.

 

Gateway is running.

 

Error:

Unable to connect to the remote server

Highlighted
Super User
Super User

Re: No longer connect to on-premise SQL Server

don;t know about SQL, but just like 15-20 mins. back , I started getting error on my connected datasources on OneDrive. I tried removing the datasource and adding it again, but consistently getting some or the other error and unable to add it.

 

Hope MS fixes this soon.


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Helper II
Helper II

Re: No longer connect to on-premise SQL Server

i just put a support ticket in.

I am sure they probably know about it by now.

I hope. Smiley Surprised

Highlighted
Super User
Super User

Re: No longer connect to on-premise SQL Server

@Gillette

I have also put a support ticket.

 

I am pretty sure that they are getting loads of support tickets right now.

 

Seems like some big issue. i am unable to add datasources from any kind of connections.


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

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

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,275)