Skip to main content

MSSQL AAG Replica secondary showing disconnected error

 Error:


You will see the secondary replica is disconnected error as:


Solution:


In this case go to SQL server and check the ERROR log and see the exact error:

Error Log location:

C:\Program Files\Microsoft SQL Server\<MSSQL15.MSSQLSERVER>\MSSQL\Log

I am able to see the error as :


There is no user and permisions.

On Node2 from SQL query run:

GO
CREATE LOGIN [RAN\SQL-AG-VM-Node1$] FROM WINDOWS
GO
GRANT CONNECT ON ENDPOINT::hadr_endpoint TO [RAN\SQL-AG-VM-Node1$];
GO

On Node2 run SQL query

GO
CREATE LOGIN [RAN\SQL-AG-VM-Node2$] FROM WINDOWS
GO
GRANT CONNECT ON ENDPOINT::hadr_endpoint TO [RAN\SQL-AG-VM-Node2$];
GO


Now try a failover and you will see both in CONNECTED





Comments

Popular posts from this blog

How to Open KVM oVirt Virtual machine console from windows

  To open virtual machine console from ovirt manager (KVM) 1. Download and Install ovirt-viewer from the below link:     https://virt-manager.org/download 2.From browser open ovirt engine and login to administrator portal 3.Right click the virtual machine and choose "Console" 4.Console file be getting created on your windows->downloads 5.Right click the file ->Properties and change the file "Opens With:" as a new program and browse till c:\program files->ovirt-viewer-> "Remote-Viewer" type 5.Now double click on the "Console.vv" file will open the console:

Deploy OVF fails Issues detected with selected template. Details: VALUE_ILLEGAL: No supported hardware versions among [virtualbox-2.2]; supported: [vmx-04, vmx-07, vmx-08, vmx-09, vmx-10, vmx-11, vmx-12, vmx-13, vmx-14, vmx-15, vmx-16, vmx-17, vmx-18, vmx-19].

 Error: While deploy using OVF file ,getting error as : Issues detected with selected template. Details: - -1:-1:VALUE_ILLEGAL: No supported hardware versions among [virtualbox-2.2]; supported: [vmx-04, vmx-07, vmx-08, vmx-09, vmx-10, vmx-11, vmx-12, vmx-13, vmx-14, vmx-15, vmx-16, vmx-17, vmx-18, vmx-19]. Solution: Open .OVF file and edit       <Info>Virtual hardware requirements for a virtual machine</Info>       <System>         <vssd:ElementName>Virtual Hardware Family</vssd:ElementName>         <vssd:InstanceID>0</vssd:InstanceID>         <vssd:VirtualSystemIdentifier>zabbix_appliance-6.2.7</vssd:VirtualSystemIdentifier>         <vssd:VirtualSystemType> virtualbox-2.2 </vssd:VirtualSystemType>       </System> to  vmx-19       <Info>Virtual hardware requireme...

HPE Morpheus UI loading hangs

  Error: After Morpheus installation, the UI hangs, saying loading. Solution: edit /etc/morpheus/morpheus.rb file and mark below parameter as "false" ui['morpheus_hub_enabled'] = false   Then run the below command to reconfigure: morpheus-ctl stop morpheus-ui morpheus-ctl reconfigure morpheus-ctl start morpheus-ui