Showing results for 
Search instead for 
Did you mean: 

Azure SQL DB connection/integration with BODS

0 Kudos

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>



0 Kudos

Hi Udaya,

Did you get any solution for this, even I have a similar requirement to connect the Azure SQL Database and experiencing similar issue.

Any update on this it would be great help if you can share with us.


Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

I don't think ODBC Driver 17 for SQL Server is supported with the DS 4.2 SP 7 and MS SQL Server2014. Check the DS PAM guide for the same, this could be the issue itself.