Im trying to connect my On-premises SSMS to Azure Data factory for data migration. When Im creating a linked service and testing it, im getting this
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: ‘IBRAHIMSQLEXPRESS’, Database: ‘AdventureWorks2017’, User: ‘admin’. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.)
The certificate chain was issued by an authority that is not trusted