Forum Discussion

Padmaja_UH's avatar
Padmaja_UH
New Member
2 years ago

dataflow fails on writetodestination step with this error - details below

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

1 Reply

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