You’re offline. This is a read only version of the page.
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
Are you able to connect to the SQL server from the management studio?
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/
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.
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/
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/
#1
Michael E. Gernaey
9
Super User 2025 Season 1
#2
bscarlavai33
5
Super User 2025 Season 1
#3
getsplash
2
Share
Report
All responses (
Answers (
