0

I want to connect to an availability group (listener ip) including 4 different database servers. In my connection string, I specify 

application intent = readonly

attribute to connect as read-only. But it fails with a

database connection error

There are two different cases:

  • when I use a database ip instead of listener ip, I can connect to the database

  • when I remove application intent = readonly, I can connect to the database

Who can help me?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
John Swayne
  • 13
  • 1
  • 5

1 Answers1

0

Did you try writing without spaces; "ApplicationIntent=ReadOnly"

Using Connection String Keywords with SQL Server Native Client

serhan
  • 1
  • 1