Answered

SQL Server Connection error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Hello

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

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

Like (0)

Report
Copy link

Link copied!

Now it's solved by It self for me also

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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