Cannot connect with read only intent when using listner name

  • Hi All,

    I have an issue when connecting with applicationIntent=readonly when using Listener name. I can connect to the read only secondary with applicationIntent=readonly if I use the server name. It gives a host does not exist error when using listener. This happens only if I am using the applicationIntent keyword. I can connect for normal readwrite operation using listener name. Does anyone have any idea why this might be?

    -Roy

  • Have you checked the readonly routing url configuration?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • You nailed it on the head. The domain name was wrong. I set it up with .com but our domain is different. Thanks Perry.

    -Roy

  • Sure no problem

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply