Questions tagged [alwayson]

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

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

SQL Server: allow access to databases of particular Availability Group only

Is it possible to configure clustered SQL Server in a way that allows users connected to a listener of an AlwaysOn Availability Group to access databases belonging only to this Availability Group? ...
0
votes
0answers
16 views

SQL Server Always On Availability Group Database Mirroring Certificate Zero Downtime Renewal Procedure?

Here I have a 2-node SQL Server 2016 AlwaysOn Availability Group cluster, with 1 primary and 1 secondary, and there are certificates that encrypt the traffic from node 1 -> node 2, and node 2 -> ...
3
votes
1answer
43 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 ...
1
vote
0answers
45 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 ...
1
vote
0answers
31 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 ...
0
votes
0answers
53 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, ...
0
votes
0answers
91 views

How to sync AlwaysOn AG in primary site with AlwaysOn AG in DR?

The primary site has 2 database servers connected to a SAN. both nodes running on SQL server 2016. Both the servers are configured to function as an always on availability group as opposed to a Fail ...
1
vote
1answer
37 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). ...
3
votes
0answers
402 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 ...
0
votes
1answer
2k 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....
1
vote
0answers
75 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 ...
0
votes
1answer
102 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 ...
1
vote
1answer
3k 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 ...
2
votes
1answer
136 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. ...
1
vote
0answers
728 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 ...
1
vote
0answers
559 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 ...
2
votes
0answers
1k 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 ...
0
votes
1answer
843 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 ...
3
votes
2answers
7k 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'...
3
votes
2answers
46 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 ...
1
vote
0answers
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 ...
0
votes
2answers
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-...
0
votes
1answer
388 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, ...
0
votes
0answers
654 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 ...
1
vote
1answer
218 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 ...
1
vote
0answers
170 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 ...
0
votes
1answer
50 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 ...
0
votes
2answers
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 ...
1
vote
0answers
505 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 ...
0
votes
1answer
924 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! ...
1
vote
1answer
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 ...
0
votes
1answer
528 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 ...
3
votes
2answers
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 ...