application_intent = readonly fails

We have installed the RSTudio Professional Drivers and are able to connect to SQL database without any issues. However, while trying to connect to SQL database using the application_intent = "read only” paramater, it fails. Not sure whether this is something to do with the syntax. Can you please suggest? Thanks.

con <- DBI::dbConnect(odbc::odbc(),

  • Driver = "SQLServer",
  • Database = "edw",
  • Trusted_Connection = "true",
  • Integrated_Security = "true",
  • Server = "x.x.x.x\TEST",
  • Application_Intent = "ReadOnly")
    Error: nanodbc/nanodbc.cpp:1118: 00000: [RStudio][SqlServer] Connection timed out. [RStudio][SqlServer] (5701) Changed database context to 'testDB'. [RStudio][SqlServer] (5703) Changed language setting to us_english.

Can someone please help with my query? Many thanks.

This topic was automatically closed 42 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.