June 7, 2016 at 8:08 am
All,
I have installed two standalone SQL 2014 Ent Edition instances. I have check that both "AlwaysOn" are turned on, on each node. I am able to failover back and forth successfully. Also, when connecting to the primary instance I am able to see all options related to the drop down of "AlwaysOn High Availability", but when I connect via SSMS using the listener, I can see any of the drop items from "AlwaysOn High Availability". I get an error stating in short "The AlwaysOn service is disabled on <servername>" and that server is the node in which the primary is located. I have checked both nodes and AlwaysOn is turned on. Please see below: (Any ideas on what's going on?)
Both nodes:
SELECT SERVERPROPERTY ('IsHadrEnabled')
output:
1
Thank you in advance for any help.
June 8, 2016 at 1:26 am
Just to double check, you have done / are able to do all of the following:
1. Cluster created successfully
2. In SQL Configuration Manager you have enabled AlwaysOn HA on both nodes
3. AG created, database added and you can failover back and forth between the nodes
4. Created the listener and can access the database /s using the listener name before and after failover
Are there any errors being reported in Failover Cluster Manger or the SQL logs?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply