I am getting "logintime out expired" Error while working on azure synase ingestion. Can someone help on this.

Have you added the port number in host_port after Azure synapse sql endpoint (usually 1433) ?

Yes I have added the port number

Would you be able to test synapse connectivity from same machine using python script mentioned here - https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-python?view=azuresql#create-code-to-query-your-database? Use simply azure synapse sql endpoint(without port) as Server.