cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
REX
Level: Powered On

Re: SQL server connection issue

Hi gax700

 

Yes my sql server connection i use is a named instance 

JRaasumaa
Level 10

Re: SQL server connection issue

I also have named instances.

 

I think the key here is that PowerApps SQL connections do not work while Power BI connections do, I was able to add a connectoin in PowerBI with no issues.

 

Is there a way to get some attention to this post to get a response from Microsoft?

Brank
Level 8

Re: SQL server connection issue

My SQL Server are named instances as well..

Anonymous
Not applicable

Re: SQL server connection issue

We are also experincing the issue. It started for us yesterday afternoon (around 3:00PM MST) We are utilizing a named instance as well.

 

The attempts to connect to the server via PowerAss don't seem to be showing at all in the SQL connection logs.

 

Session ID: 82e4e1a6-bc94-f634-2640-fb2ef8362556

JRaasumaa
Level 10

Re: SQL server connection issue

I just noticed in testing again that the Source in the error is adding a second \ in the server name

 

It's showing as:

 

SERVERNAME\\INSTANCE;DATABASE

 

instead of:

 

SERVERNAME\INSTANCE;DATABASE

 

I can't get it to work otherwise, just posting to see if this helps shed some light!

jroderick
Level: Powered On

Re: SQL server connection issue

Same exact issue here.  I guess I will stop trying to fix this and wait to hear more...

 

bradamson
Level: Powered On

Re: SQL server connection issue

I also haved a named instance here.  

Lonache
Level: Powered On

Re: SQL server connection issue

Ditto.  Named instance.

Brank
Level 8

Re: SQL server connection issue

@SinanE can you please take note about this issue that is critical for us? Specially in the apps that we are using for work and are in production environments.

Power Apps Staff SinanE
Power Apps Staff

Re: SQL server connection issue

We are treating this as a high priority issue and actively investigating. You can also look at the note at this page https://powerapps.microsoft.com/en-us/support/ , which should have more information once we identify the issue.

 

Thanks.

 

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,134)