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..

jsarnold
Level 8

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.

PowerApps Staff SinanE
PowerApps 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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,863)