Manual Failover of Window Failover Cluster

Use Transact-SQL To manually fail over an availability group: Connect to the server instance that hosts the target secondary replica. Use the ALTER AVAILABILITY GROUP statement, as follows:ALTER AVAILABILITY GROUP group_name FAILOVER In the statement, group_name is the name of the availability group.The following example manually fails over the MyAg availability group to the connected secondary replica: Sources:

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

Error: Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Reason: Token-based server access validation failed with an infrastructure error. Source Logon Message Error: 18456, Severity: 14, State: 11. Note: This error seems to happen when trying to query the database using SQL Server Manager Studio (SSMS) on a remote computer. This error does not happen when... » read more