It is a pain that HA wizard does not consider the login mappings re SID

Does SQL Server HA has 0 down solution?

Even in SQL Server 2014 AlwaysON, then failover to secondary node, the application side need to reconnect.

Actually just checked out http://www.sqlservercentral.com/Forums/Topic489200-145-1.aspx, figured out the answer.

It is not related to the permission, xp_fileexist does has the information but it is not a output parameter, so...

It is network account(domain account), it has permission to run backup etc.

All SQL Servers runs under same service account.

I can use xp_* commands to check if file exists, list sub folders, just xp_fileexist cannot work UNC folder, it works for file's...

Thanks Buddy, I will give it a try!

Our application does the backup, so all through primary, and there are both primary replicas on both node A and B, so it is balanced...

Hello Perry,

Thanks for your reply.

I found another database out of sync on another server, I tried to apply the log backup but there are not enough log backup since...

We have lots tickets with MS re AlwaysOn

even you leave the current status for them remote in to investigate, they will say not enough information.

Here are my summary to fix...

setup a linked server to the reporting database, run a sql agent query to save result to reporting database, check reporting database or write a SSRS report.

Or you can setup...

I don't understand in the SQL Diag log, it says caused by client or server login timeout expiration, but from the log itself, the time spent during all stages are...

cannot share photo though, the photo link is http://s30.This image host is not supported, please use another/tvnvvvsxd/alwayson_001.png

Lots connection timeout and waitforharden found in extend events.

above error occurs every hour, but the SQL Server AlwaysON doesn't seem to be affected every hour...

I looked through the errors in Cluster Events, there are 3 type of errors keep being generated for many cluster resources every hour, there are no other errors

Message 1:

Cluster resource...