November 24, 2014 at 7:50 am
Adam Bean (11/24/2014)
When I connect to the listener with ;ApplicationIntent=ReadOnly, it still lands on the current primary (which is SQL01\AO1):Shouldn't I have landed on SQL03 first?
Are you specifying the listener name and database name in your connection string?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 7:52 am
Ya got me again. Previously I was specifying the database, this time I was not. As soon as I specified the database, it indeed took me to 03.
Thank you much for your help, most appreciated!
November 24, 2014 at 8:01 am
Adam Bean (11/24/2014)
Ya got me again. Previously I was specifying the database, this time I was not. As soon as I specified the database, it indeed took me to 03.
😎 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply