Testing AlwaysOn routing URL using SQLCMD

You have created a listener and have configured routing URL for the replicas in the AlwaysOn group. When you are trying to check if the routing URL is working as expected by trying to connect from SQLCMD using the below command: sqlcmd -S Listenername,portnumber -d databasename -K ReadOnly   you are getting the below error…

0

AlwaysOn:Joining database on secondary replica resulted in an error

Many a times when you try to create a new Availability group it would fail with the below error message :   TITLE: Microsoft SQL Server Management Studio—————————— Joining database on secondary replica resulted in an error.  (Microsoft.SqlServer.Management.HadrTasks) ——————————ADDITIONAL INFORMATION: Attempting to join availability group resulted in an error. (Microsoft.SqlServer.Management.HadrTasks) —————————— Failed to join the…

0