All,

Thanks for your help.

It works OK on Edge for me (I haven't tried IE).

Apologises for not mentioning the browser in my first post.

Thanks

I'm not sure if this helps so apologises if I'm wasting your time but when the ping fails is it because?:

a) It fails to find an IP in the DNS

b)...

Thanks for your reply. Firefox 78.0.2 (64-bit) on Windows 10. I've just tried a private session and that didn't work either.

I'll try some other browsers tomorrow and update the post...

Something I've found on 2016 and 2017 (I appreciate you are using 2014, I don't know if it's the same) is that if you use a maintenance plan that does...

Firstly, are you running SQL Server 2008? I ask because you posted in the 2008 forum section but I think Availability Groups were introduced in 2012. I could be wrong.

The...

My understanding is that...

Your system is more complicated than the ones that I've used so I can't share any experience with you.

However I did notice one thing - You said that database A...

Unfortunately I can't give you a 'yes' or 'no' answer to the question of the separate database because it depends on too many surrounding items including, but not limited to,...

• This reply was modified 5 years, 2 months ago by as_1234. Reason: "Read-intent configured" removed for listener A in the example layout because I used basic availability groups in the example and they don't support read-intent

No problem and thanks for your advice

Can I ask what you are trying to achieve by having a separate name? You maybe able to achieve your objective by using a listener and read-intent.

If you are using SQL server agent then you might need to check that this is running OK. It's separate from SQL Server so it's possible for SQL server to...

Thanks for your reply and information.

I've not heard the phrase triangular joins before. Does it refer to the following situation?:

Table A is joined to Table B

Table A is joined...

I haven't used this configuration so I can't answer your question directly.

Are your clients connecting to a listener and specifying readintent? If they are then the infromation here https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-only-routing-for-an-availability-group-sql-server?view=sql-server-ver15 might...

Which software are you using?