The Server name provided does not match the the server name on the SQL Server SSL Certficate

[Anonymous]

please help with this error, i am learning fabric with data factory, i did a datalake and want to use sql endpoint but i keep getting this error

[Anonymous]

Hi,@Anonymous I am glad to help you.

Based on your description, it seems that you have an authentication mismatch when creating a dataflow connection in DataFactory!
In order to reproduce your error, I performed the following test:
I tried to create a dataflow in DataFactory
Here the gateway connection authentication method I recommend you to use Windows (Authentication kind)
Authentication by entering the domain user account of the domain in which the database instance is located.

get the domain User:

whoami

I test:create a dataflow in the datafactory

Connected successfully.

Login by domain name\user name

Could you please provide me with some information on where you are getting this error, is it when you are creating a datafactory with the same data source as me, and if so could you provide me with a screenshot that does not contain sensitive data?
Luckily, I found a post with the same problem as yours and it has been resolved, I hope it helps.
URL:
https://community.fabric.microsoft.com/t5/Desktop/The-server-name-provided-doesn-t-match-the-server-name-on-the/m-p/135898

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.