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

Announcements

Welcome to the Power Platform Communities
Register Today: Microsoft Business Applications Update- April 15th
Your Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Connection problem wit...
Power Apps
Unanswered

Connection problem with MSSQL

(0) ShareShare
ReportReport
Posted on by Lam852 6

I have a PowerApps that I've been using continuously. It connects to SQL Server 2019 using MSSQL. I've already installed the On-premises data gateway, but recently I've encountered a connection error that prevents me from using it. Please advise on how to resolve this issue.

The error message that appears is as follows:
Test connection failed. Details: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - This certificate chain is not issued by a trusted authority.) inner exception: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - This certificate chain is not issued by a trusted authority.) clientRequestId: 11b83167-a7fd-d9ea-d9a5-06e5eeef522b

 

Categories:
Governance & administering
I have the same question (0)
  • velegandla Profile Picture
    velegandla 204 Moderator on at

    @Lam852 

     

    Did you update the gateway to the latest version?

     

    ====================================================

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    https://www.linkedin.com/in/devendravelegandla/ 

  • Lam852 Profile Picture
    Lam852 6 on at

    Yes, I have install the latest version

  • velegandla Profile Picture
    velegandla 204 Moderator on at

    @Lam852 

     

    sorry one more question. Does the logs at Data gateway shows any errors?

     

    ====================================================

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    https://www.linkedin.com/in/devendravelegandla/ 

  • Lam852 Profile Picture
    Lam852 6 on at

    where can i find this error log?

  • velegandla Profile Picture
    velegandla 204 Moderator on at

    @Lam852 

     

    https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot#troubleshooting-tools 

     

     

  • Lam852 Profile Picture
    Lam852 6 on at

    i can see some like this, but i have no idea how to solve,

     

     

    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.2993055Z DM.EnterpriseGateway 726f5512-fdb1-475d-9aaf-792d67710486 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEA ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 A1272C73 [DM.Pipeline.GatewayPipelineTelemetry] Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupValueException (0x80004005): Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 此憑證鏈結是由不受信任的授權單位發出的。)
    於 Microsoft.Data.Mashup.ProviderCommon.MashupResource.<>c__DisplayClass48_2`1.<StartEvaluationAndGetResultSource>b__0()
    於 Microsoft.Mashup.Security.Impersonation.RunAsProcessUser[T](Func`1 func)
    於 Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
    於 Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
    於 Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorUtils.MashupExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest, Guid activityId)
    於 Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest, Guid activityId)
    於 Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass4_3.<<ExecuteAdoQueryAsync>b__3>d.MoveNext()
    --- 先前擲回例外狀況之位置中的堆疊追蹤結尾 ---
    於 System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    於 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    於 Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivityAsync>d__7`1.MoveNext()
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.2993055Z DM.EnterpriseGateway 726f5512-fdb1-475d-9aaf-792d67710486 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEA ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=1526, err=MashupValueException, rootcauseErrorEventId=0)
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3352127Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 8B21C03B [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: Microsoft SQL: <ccon>A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 此憑證鏈結是由不受信任的授權單位發出的。)</ccon>; ErrorShortName: MashupDataAccessValueException[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259,HResult=-2147467259]
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3352127Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <ccon>-2147467259</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <ccon>[ccon]Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 此憑證鏈結是由不受信任的授權單位發出的。)[/ccon]</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingHResult = <ccon>-2147467259</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.Class = <ccon>20</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.DataSourceKind = <ccon>SQL</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.DataSourcePath = <ccon>SQLSERVER;powerapps</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.ErrorCode = <ccon>-2146232060</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.Message = <ccon>A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 此憑證鏈結是由不受信任的授權單位發出的。)</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.Number = <ccon>-2146893019</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.Reason = <ccon>DataSource.Error</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3382003Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.State = <ccon>0</ccon>
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3421895Z DM.EnterpriseGateway 80297291-e247-488f-9e1d-e03ada895229 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGEQ ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=1684, err=MashupDataAccessValueException, rootcauseErrorEventId=0)
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3421895Z DM.EnterpriseGateway 98f706a4-aaaf-41de-9e86-6dba2dd88d93 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MGPP ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=1773, err=MashupDataAccessValueException, rootcauseErrorEventId=0)
    DM.EnterpriseGateway Error: 0 : 2024-05-14T01:48:25.3621102Z DM.EnterpriseGateway 28dd0d0e-bbfb-434d-9917-da35508c0937 11b83167-a7fd-d9ea-d9a5-06e5eeef522b MDSR ad072564-6979-4e02-9533-1dee9339bdf1 65f33850-ba76-4d52-913b-72e8fb657031 65f33850-ba76-4d52-913b-72e8fb657031 4C1EF73E [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: <ccon>Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 此憑證鏈結是由不受信任的授權單位發出的。)</ccon>
    TemplateMessage: Mashup expression evaluation error. Reason: DataSource.Error.

     

     

  • velegandla Profile Picture
    velegandla 204 Moderator on at

    @Lam852 

     

    Are you able to connect to the SQL server from the management studio?

     

    https://learn.microsoft.com/en-us/sql/ssms/quickstarts/ssms-connect-query-sql-server?view=sql-server-ver16 

     

    If yes, you maybe need to raise a Microsoft support ticket to troubleshoot the issue. 

    ====================================================

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    https://www.linkedin.com/in/devendravelegandla/ 

  • MF-23101206-0 Profile Picture
    MF-23101206-0 18 on at
    Did you find a solution for this issue? I just got a gateway setup and am trying to set up the sql server connection and I am getting this same error. I am able to login through SSMS, but have to have the Connection Settings properties set to Encryption= Optional and Trust Server Certificate is checked. Not sure how to resolve this in power automate though.

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

News and Announcements

Welcome to the Power Platform Communities
Register Today: Microsoft Business Applications Update- April 15th
Your Invited to Keeping It Real with the Power Platform

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans