March 7, 2013 at 5:00 pm
I'm trying to set up an SQL 2012 Availability Group between 'ServerA' and 'ServerB'
On the source server (ServerA) I get the following message in the 'AlwaysOn High Availability' tab in SQL Server Configuration Manager: 'An error occurred while loading the AlwaysOn High Availability properties [return code: 0x80070005]. This server is running Windows Server 2008 R2 Enterprise and SQL Server 2012 SP1 Enterprise edition, but I can't confirm if the hotfix in KB2494036 has been installed as I don't have admin rights on the server (don't ask). The server admin said he was going to install it last night but I haven't confirmed with him, and he's left the office for the night.
On the destination server (ServerB) I get the standard error message saying that SQL 2012 Enterprise Edition, Windows Server 2008 and KB2494036 need to be installed. This server is also running Windows Server 2008 R2 Enterprise and SQL Server 2012 SP1 Enterprise edition, and I can confirm the hotfix has been installed.
When I try to run the Availability Group wizard on ServerA, on the Replicas tab, when I put in the credentials for ServerB, I get the error message: "Cannot connect to QA-SQL-LOAD1\VRS70. AlwaysOn feature is not enabled on SQL Server instance 'QA-SQL-LOAD1\VRS70'. (Microsoft.SqlServer.Management.HadrTasks)"
Getting clear installation and troubleshooting documentation on setting this up has been quite challenging (which might be part of my problem...) - does anyone have any ideas on where to go from here?
TIA,
Mike
July 2, 2013 at 4:24 pm
I'm also facing a similar issue with Server 2012 DC Edition. I'm trying to readd a third node which is not showing in the Cluster although when I try to add it, it says it already exists. When I try to check the box, "Enable AlwaysOn Availability Groups" I get the error return code [0x8007053a]
I tried the following:
cluster node [nodename] /ForceCleanup which did not work
I tried stopping the Cluster Service on the SQL Server (under services)
Looked in Event Viewer under Applications And Service Logs > Microsoft > Windows > Failover Cluster Manager
Anyone solve this issue? I can ping from both servers back and forth. I also verified IPV6 is disabled on both network adapters.
March 22, 2018 at 11:18 am
I added the computer to the windows failover cluster using the same named admin tool.
Then I ran the powershell script as admin:
Enable-SqlAlwaysOn -Path SQLSERVER:\SQL\<machine name>\<instance name>
Let stew one day (must recycle something)
and walla, working!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply