dataflow fails on writetodestination step with this error - details below

[Padmaja_UH]

999999 Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) Details: Reason = DataSource.Error;DataSourceKind = Lakehouse;DataSourcePath = Lakehouse;Message = A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.);ErrorCode = -2146232060;Number = 121;Class = 20;State = 0;Microsoft.Data.Mashup.Error.Context = User GatewayObjectId: 0b462d6e-96ea-4a93-813f-f1af6066bdb0

[lbendlin]

Ask the owners of the SQL Server data soure if they are enforcing a timeout setting on their side.