Skip to Content
May 20, 2021 at 12:55 PM

Azure SQL DB connection/integration with BODS


Hi Experts

Problem: Connection timeout.

Trying to connect the Azure DB from DS by configuring Data Store like below. On first connection attempt to DB from DS, after 30 seconds I get below error message but the job is successful, second attempt and subsequent attempts are always successful and could extract/load data accordingly, I understand the error is happening due Azure DB is on sleep mode on first attempt.

I have checked other questions but could not resolve my issue.

DS Version: SP07

MS SQL Server 2014.

Please guide me with right config or suggest the steps to resolve this issue

  • ODBC Driver Issue ?
  • Connection timeout to increase on Azure DB ?

Error Msg in DS:

ODBC Driver used are:

Configured using these drivers, but both failed in first attempt

Data Store in DS:


ODBC call <SQLDriverConnect> to connect database <DS_XXX_INT> failed with error: <ODBC call <SQLDriverConnect> for data source <DS_XXX_INT> failed: <[Microsoft][SQL Server Native Client 11.0]TCP Provider: Timeout error [258]. [Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in login response [Microsoft][SQL Server Native Client 11.0]Login timeout expired>




error-msg.png (17.0 kB)
odbc-drivers.png (4.6 kB)
ds-in-bods.png (6.2 kB)