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",
- Server_SPN = "MSSQLSvc/AL-UAT-TEST: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.