Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [alwayson]

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

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

34 questions
1
vote
1 answer

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 present the following two errors. The error makes…
Eric C. Singer
  • 2,329
  • 16
  • 17
1
vote
0 answers

Fortify Software Security Center Database (HA) Issue

We have deployed Fortify Software Security Center in an environment with configured MSSQL ssc_db. How would I configure the High Availability Database configuration in Fortify SSC if possible? Otherwise, if I can enable the option Always On…
Shahab Ali
  • 11
  • 1
1
vote
0 answers

MS SQL Always-On Listener DNS entry lost in domain due to scavenging - should this be expected?

When running MS SQL with an Always-On group / listener, is it expected that the always-on listener DNS entry be kept active in the domain's DNS? When the listener was created, a DNS entry was added to AD DNS server with multiple IPs as part of the…
Brett
  • 221
  • 3
  • 11
1
vote
2 answers

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 Windows 10 and Windows 11 PCs) without any hints…
Nik
  • 21
  • 3
1
vote
1 answer

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 returns an acknowledgement to the primary…
Cat Mucius
  • 155
  • 1
  • 11
1
vote
0 answers

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 which empty itself on every system boot. My task is…
Yishai
  • 11
  • 1
1
vote
0 answers

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 admin rights. Can I use a Service Account, or a…
HansdieWurst
  • 11
  • 2
1
vote
1 answer

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). Recently, I added another server to the AG, but…
Alberto Medina
  • 299
  • 2
  • 11
0
votes
1 answer

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.119.192/26 10.68.79.240/28 Node DB1 is on here,…
Nik
  • 228
  • 3
  • 14
0
votes
1 answer

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 network NICs to communicate with each other. These…
ajh4
  • 1
  • 1
0
votes
1 answer

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 is instantaneous every time. If I instead connect…
NorthFork
  • 151
  • 6
0
votes
2 answers

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-specific error occurred while establishing a…
leeman24
  • 147
  • 1
  • 9
0
votes
1 answer

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, and I was still able to write queries. I started…
leeman24
  • 147
  • 1
  • 9
0
votes
0 answers

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 simple tests. Ex. Manual failover using SQL…
leeman24
  • 147
  • 1
  • 9
0
votes
1 answer

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 AlwaysOn Group is also not available. Is there any…
deejaylight
  • 1
  • 1
1
2
3