← ClaudeAtlas

sap-sqlserver-alwaysonlisted

SQL Server Always On Availability Groups under SAP NetWeaver — listener-based connection configuration (SAPDBHOST, dbs/mss/server, MSSQL_SERVER, MultiSubnetFailover and the case-sensitive JDBC parameter), why logins must be created by SWPM "Configure additional Always On Node" and never manually, the readable-secondary rules including the unsupported "Yes" setting, sync vs async and the latency guidance, WSFC without shared disks, and per-node failover verification. Also covers Database Mirroring. Use for "SQL Server AlwaysOn SAP", "availability group", "listener", "MultiSubnetFailover", "readable secondary", "SAP cannot connect after failover", "error 976".
adam0thman/sap-basis-ops · ★ 0 · API & Backend · score 72
Install: claude install-skill adam0thman/sap-basis-ops
# SQL Server Always On under SAP NetWeaver **Source of record.** **SAP Note 1772688 — *SQL Server Always On Availability Groups and SAP NetWeaver-based applications***, version **25**, released **21.01.2026**, component BC-DB-MSS **[V]** — fetched and read directly. > ## 🛑 This Note is the only supported source > > Note 1772688, verbatim: *"This SAP Note centralizes the setup and configuration details for > AlwaysOn. **Only the procedures explained here in this SAP Note are supported** for SAP > installations on AlwaysOn. As of July 2020, **please do not use external blogs, other SAP Notes, or > outdated SAP installation and upgrade guides** when working with SAP NetWeaver on AlwaysOn."* **[V]** > > That is unusually strict, and it applies to this skill too. **Treat this file as a map to the Note, > not a replacement for it** — read the live Note before executing a lifecycle procedure. **Scope:** NetWeaver-based products only. For **non-NetWeaver** products (SAP BusinessObjects, SAP Redwood) this Note does **not** apply — find the documentation for that application area. **[V]** --- ## 1. Support baseline | | | |---|---| | **NetWeaver** | AlwaysOn supported from **7.0** and all later releases **[V]** | | **SQL Server 2012+** | AlwaysOn — **strongly recommended** over Database Mirroring **[V]** | | **SQL Server 2008 R2 or earlier** | Use **Database Mirroring** instead (SAP Note **965908**) **[V]** | | **JDBC** | Automatic failover via the listener name needs **Microsoft