Questions tagged [alwayson]

High Availability/Disaster Recovery (HADR) feature in Microsoft SQL Server 2012 and above.

Filter by
Sorted by
Tagged with
0 votes
0 answers
178 views

Always-On VPN profile does not add custom route

My server is 2012R2. I deployed AOVPN according to Microsoft manual using PowerShell for clients deployment. It all works except custom route just does not appear on a client (tried on multiple ...
user avatar
  • 11
1 vote
1 answer
76 views

Data consistency in SQL AlwaysOn Availability Group

I have an AlwaysOn cluster of SQL Server 2019, containing an Availability Group of 3 replicas in Synchronous mode. According to Microsoft documentation: The secondary replica hardens the log and ...
user avatar
3 votes
1 answer
474 views

SQL Server Always On Availability Group Zero Downtime Update Procedure

Here I have a 2-node SQL Server 2016 AlwaysOn Availability Group cluster, with 1 primary and 1 secondary. The question is - what is the optimal way to install Microsoft Updates on the servers in the ...
user avatar
  • 319
1 vote
0 answers
137 views

Failover Cluster Missing Disks

I'm stuck with a weird situation to which i could not find a solution. I Have 3 AWS instances (windows server 2019) joined to a failover cluster and each one of them have an instance store volume ...
user avatar
  • 11
1 vote
0 answers
35 views

Is admin the least required Permission Role to start SQL Always On Instance?

We've got an SQL 2019 Enterprise with Always On. Everthing works fine, but the user, which is starting both instances has admin rights. So I want to change this, but all tutorials are talking about ...
user avatar
0 votes
0 answers
108 views

SQL Server 2012 AAG not failing over in case of SQL Server crash/stop

I have created the following structure: Two hardware servers with Windows Server 2012R2 installed, SQL Server 2012R2 installed. Then Windows went fully updated and SQL Server was patched to SP4, ...
user avatar
  • 734
1 vote
1 answer
73 views

Databases "Synchronized / In Recovery" after adding server to SQL Avaylability Group

I have an SQL AlwaysOn Availabilty Group configured with 2 nodes. The AG works without any problem with this 2 nodes and I can do a failover to/from any of them (this servers are on the same network). ...
user avatar
3 votes
0 answers
545 views

Windows Server Failover Clustering - cannot choose desired subnet when creating

I'm setting up a new WSFC cluster, intended for SQL HA, but that's not actually important as yet. Node A has: An IP in Subnet 1: this is where the machine's "primary" IP is, set by the hoster. An ...
user avatar
  • 228
0 votes
1 answer
3k views

Cannot add SQL Server Always On Availability Group Listener to second subnet

I have a WSFC cluster between two 2016 nodes - DB1 and DB2. (Cluster Network 1 and 3 are set to NOT carry cluster traffic.) Failover cluster manager shows that Cluster Network 2 has two subnets: 10.70....
user avatar
  • 228
1 vote
0 answers
78 views

Using AlwasyOn Failover Cluster Instance in conjunction of Peer to Peer Transactional Replicaiton

We are deploying two physical sites each with writable/readable access to its local SQL server. Each site has site redundancy and also cross site synchronization is required. My thought is to use the ...
user avatar
0 votes
1 answer
153 views

Multihomed Computers - wont communicate on a network

I have two multi-homed servers connected to each other via a private network and also via a public network. I cannot get traffic to go across the private network. The servers only use the public ...
user avatar
  • 1
1 vote
1 answer
4k views

MS SQL 2016 AlwaysOn cluster on Win2012R2 - AGs failover if File Share Witness is down

Our current setup includes: eight (8) Windows 2012 R2 nodes in single Failover Cluster, no shared storage, File Share Witness (on DC) MS SQL 2016 AlwaysOn with a few AG groups default 'If resource ...
user avatar
2 votes
1 answer
139 views

AlwaysOn SQL VNet Migration from Azure V1 (ASM) to V2 (ARM)

Hoping someone can help! Currently in the middle of planning a migration from Azure Service Manager to Azure Resource Manager. Not able to find any documentation and thought I would reach out. ...
user avatar
1 vote
0 answers
744 views

Windows Failover Cluster node in Azure - Assigning a cluster IP address

I've built a 2-node Windows Server 2012 R2 failover cluster, one node being in my on-premises network and one being an Azure (Resource Manager deployment model), in part following this MS article In ...
user avatar
1 vote
0 answers
620 views

SQL Server 2016 Always Encrypted and AlwaysOn readable secondary connection error

I've used Always Encrypted in SQL 2016 to encrypt the data in a few columns of a table in my application. Always encrypted appears to be set up correctly, because I can see the encrypted data in SSMS ...
user avatar
  • 151
2 votes
0 answers
2k views

Windows Failover Clustering Wont Release IP Address

I have setup a windows failover cluster on two servers on Windows 2012R2 with a file share for quorum. On top of this I have deployed SQL Server 2016 Always On Configuration and if I manually fail ...
user avatar
  • 121
0 votes
1 answer
1k views

Intermittent timeouts connecting to Availability Group Listener

I have a database in a SQL Server Availability Group running on a database server. If I log into my web server and connect to the primary database directly by the database server IP the connection ...
user avatar
  • 151
3 votes
2 answers
8k views

Error configuring File Share Witness in a Windows 2012R2 Cluster

I'm learning how to configure a simple W2012R2 Cluster for a AlwaysOn Basic Availability Group. I have this VM scenario: - 1 DC (outside the cluster) - 2 SQL Server Standard 2016 (in a Cluster) I'...
user avatar
  • 173
3 votes
2 answers
55 views

SQL 2012 Standard - AlwaysOn FCI - Single point of contact?

I am looking at HA options for SQL 2012 Standard. I like the look of AlwaysOn FCI. I am using a SAN, so I think I can meet all of the requirements, but one of the applications I am looking at cannot ...
user avatar
  • 33
1 vote
0 answers
2k views

Unable to create cluster in Windows Server 2012 R2

I am trying to create a cluster in between two networks/gateway and validation is perfectly passing and after that i am getting error as An error occurred while creating the cluster and the nodes ...
user avatar
0 votes
2 answers
2k views

SQL 2012 Availability Group Doesn't Failover When Shutting Down Service

I am having an issue with SQL 2012 Availability Groups where it does not fail over when shutting down the service. When you shut down the service you will get an error: A network-related or instance-...
user avatar
  • 147
0 votes
1 answer
399 views

SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

I am setting up a 3 node cluster as part of an availability group. Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, ...
user avatar
  • 147
0 votes
0 answers
671 views

SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for User

I am trying to get SQL 2012 AlwaysOn Availability Groups working for an application. The cluster has 2 SQL nodes and 1 witness server. Everything appears to be failing over successfully when I do ...
user avatar
  • 147
1 vote
1 answer
252 views

How to setup user accounts on a secondary server in High Availability?

Working with two Microsoft SQL 2012 servers in Always On High Availability configuration running on Windows Server 2012 R2. Setup works well and failover is almost flawless. However, the software ...
user avatar
  • 301
1 vote
0 answers
186 views

Run generic Windows Service with affinity for the Primary Replica of an SQL Server AlwaysOn Availability Group

Is it possible to configure a generic Windows service in a Windows Server Failover Cluster such that the service always runs on the same machine as the Primary Replica (read/write) of an SQL Server ...
user avatar
0 votes
1 answer
51 views

SQL alwaysON and WSFC

I have a WSFC configured on 2 (hardware)nodes with SQL AlwaysOn group. The problem is, if the node Where I have created the cluster goes down the cluster is not available for second node and here ...
user avatar
0 votes
2 answers
4k views

Windows Server Failover Clustering with two servers

I was going to create a Windows Server Failover Cluster, in order to set up MS SQL Server AlwaysOn Availability Groups. As a prerequisite of failover clustering, I've created and configured an ...
user avatar
  • 113
1 vote
0 answers
534 views

No messages received on Queue after Failover in SQL Always On

We have an Application, which uses Service Broker to receive notifications from the SQL Server. The application works fine when we don’t have SQL Always On enabled, and when we are interacting with a ...
user avatar
  • 11
0 votes
1 answer
935 views

Automatic failover in SQL server alwayson availability group

I have 2 nodes in my SQL server fail over cluster. I use SQL server 2012 always on feature for HA purpose. The problem is that when one my server goes down the automatic fail over does not happen! ...
user avatar
1 vote
1 answer
1k views

SQL AlwaysOn auto fail over due to disk

All, I'm in the process of evaluating SQL AlwaysOn, and everything is failing over as expected, except in one circumstance, when the disk goes belly up. In this case, SQL does nothing, other than ...
user avatar
0 votes
1 answer
530 views

AlwaysOn Automatic Failover Using Two Nodes with SQL Standalone Instances

We are building a new SQL 2012 cluster for our web environment. We decided to use two nodes and utilize AlwaysOn Availability Groups for High Availability. Server01 and Server02 have had a Standalone ...
user avatar
3 votes
2 answers
1k views

Dealing with Stretch (Geo) Cluster Node Failures

Scenario: Three node (shared nothing) cluster on Windows Server 2012. Two nodes in the primary data center, both with votes (node weight = 1), and a file share witness. The third node is in a remote ...
user avatar