Unanswered

SQL Server Connection error

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am using a connection to SQL Server with my flow. I have installed the gateway and Flow founds the server, the database name and the table name. But when trying to connect It makes this error:

Http request failed with unhandled exception of type 'ADAuthenticationException' and message: 'AADSTS700030: Invalid certificate - subject name in certificate is not authorized. SubjectNames/SubjectAlternativeNames (up to 10) in token certificate are: TIP0-FRA-xrm-user.flow.microsoft.com. Trace ID: 5341847b-0659-492c-9c61-ae379e89a500 Correlation ID: ef940ade-cb3e-4179-a85e-ca76bc42636b Timestamp: 2020-07-13 13:30:46Z'.

Could you help please.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

vkhuoy 4 on at

Like (0)

Report

same issue here... since this morning. Have this error when we tried to modify a flow that uses AzureAD Component

Error: Http request failed with unhandled exception of type 'ADAuthenticationException' and message: 'AADSTS700030: Invalid certificate - subject name in certificate is not authorized. SubjectNames/SubjectAlternativeNames (up to 10) in token certificate are: TIP0-FRA-xrm-user.flow.microsoft.com. Trace ID: 7c00e708-901e-469d-ad9d-0145b98b5500 Correlation ID: 0ccbad56-2cbd-4a66-9e9c-589dc415c623 Timestamp: 2020-07-13 16:49:21Z'.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @Anonymous ,

Does the flow works before and failed with the error suddenly?

Does the issue still exists?

Have you take a try to create a new connection to the SQL server?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It was working correctly and I tested the flow. it was Ok then it makes error when i changed the table in the BD.

I still having same problem unfortunately

Was this reply helpful? Yes No
vkhuoy 4 on at

Like (0)

Report

Hello

the problem has solved by itself yesterday around 8 PM (GMT+1)...

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Now it's solved by It self for me also

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

Hi @Anonymous ,

It seems that a temporary issue and I'm glad that the issue is solved now.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No