I am not sure which version you are referring to but I...

An update in case it helps anyone else. I created a third host and I was able to create a cluster between server 2 and 3. I'm not sure what...

If you have access to the connection strings then, if you haven't already, it might be worth having a look at the multisubnetfailover parameter. It's supposed to improve the reconnection...

• This reply was modified 5 years, 9 months ago by as_1234. Reason: Grammar correction

Thanks for your help.

I've just re-run the validation and it warns of:

The fact that there is only one network card in each host. I doubt that's the cause of the...

I can't answer your question about new connections but any existing connections, and therefore any queries using them, will be dropped during a manual or automatic failover.

Just a small addition. With availability groups, on Standard Edition, you can only have one database per availability group (You can have more than one availability group though). You also...

'Always on' is a term Microsoft use for a few different availability solutions. Have you decided which one you will use? There are some details on the differences here https://docs.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver15

The...

Is anything showing in the cluster or SQL server logs?

Does your cluster only consist of the two servers or do you have a third item such as a File Share...

Sorry I can't answer the question you asked but I can suggest something that might help avoid it in the future.

Does the Windows Cluster only have the two nodes in...

I think this might work:

select #dummy.Policy,#dummy.batchmonth, #dummy.Amount,isnull(#dummy2.Amount,0) as previousbatchmonth from #dummy left outer join #dummy #dummy2
on #dummy.Policy=#dummy2.Policy
and ((cast(#dummy.BatchMonth as int)-cast (#dummy2.BatchMonth as int )=1)
or (#dummy.BatchMonth=12 and #dummy2.BatchMonth=1))

Others...

Thanks for the correction. Sorry I was reading through active topics and didn't notice that it was only the junk advertising post that was recent. I'll avoid making that mistake...

Could it be something in the firewall between the zones? Maybe a max connection time? Or perhaps, for some reason, it's seeing the connection as idle and dropping it?

Sorry if...

Thanks for your help.

I don't know of any online servers that you can use...

I am not an expert at reading the logs but it does look like a failover occurred. I think the following happened:

The Windows cluster failed over

The users would have lost...