196 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
356
views
Unable to Deploy SSIS packages after migrating from SQL Server 2017 to SQL Server 2022 AAG
We've recently tried to upgrade from SQL Server 2019 to SQL Server 2022 Always on. SSISDB works fine up until I add it to the availability group. Since adding I get the following error when trying to ...
0
votes
1
answer
95
views
Half of connections fail with "Timeout expired" in .NET 4.0 app — is MultiSubnetFailover supported?
I’m working on an old enterprise ASP.NET MVC project (targeting .NET Framework 4.0) which connects to a SQL Server database. Recently, our infrastructure migrated from AWS RDS to an AlwaysOn ...
2
votes
1
answer
82
views
AmbientLifecycleCallback does not get called
I want to write an Always-on app for Wear OS. My Samsung watch is using Android 14.0.
Minimum SDK is set to 29, target and compilse SDK to 35.
Added WAKE_LOCK permission to the manifest.
Below you can ...
-1
votes
1
answer
1k
views
PowerShell command to add a new IP\Subnet to Windows Cluster
I have a working 2 node Windows Cluster that runs SQL Server Always On Cluster. This cluster is sitting on 10.11.x.x subnet.
I need to get this cluster ready for possible DR scenario.
I need to add a ...
2
votes
1
answer
427
views
create azure functionapp from docker image via cli
I deployed an azure functionapp with the preview Flex Consumption plan, which doesn't include 'Site.SiteConfig.AlwaysOn' which i do not want.
When deploying via CLI like so:
az functionapp create --...
-2
votes
1
answer
288
views
Very Slow Connection with AG Listener IP in Cluster Node [closed]
We have many databases in a cluster with two nodes. Every DB has a single IP listener.
Let's say Nodes are:
X-DB01
X-DB02
And DB name is APP_DB with listener: 172.22.2.22,1433
Our observations:
...
1
vote
1
answer
489
views
Could not obtain SQL Server Service information. An attempt to connect to WMI on MSSQLSERVER failed The RPC server is unavailable
I'm trying to automate enabling SQL Server Always on Availability. I'm running PowerShell as administrator. I'm a domain admin and in the local Administrators group through membership in the AAD DC ...
0
votes
0
answers
2k
views
SQL Server Always On Availability Groups are green, but manual failover attempts consistently failing ("duplicate IP address", etc. in cluster logs)
We're running SQL Server 2017 Enterprise Edition on a pair of EC2 instances (we'll call them "P1" and "P3" here) in AWS. Each EC2 instance runs two instances of SQL Server (one ...
0
votes
0
answers
69
views
Transactional replication on dedicated server using AG Listener
I have dedicated server to setup transactional replication.
i want to replicate 3 tables only Availability Database.
The tricky part is, I want my transactional replication to continue automatically ...
0
votes
0
answers
1k
views
SQL Connection String Read Only Routing without ApplicationIntent=ReadOnly workaround
I am currently utilizing SQL Server with an Always On Available Group. In my AG, I have a primary active node and a secondary node used for read only queries. To access the secondary node, we pass ...
0
votes
0
answers
284
views
How is data loss possible if we lose primary in Read-Scale (clusterless) AG Sync-commit configuration (SQL Server AlwayOn)?
Microsoft documentation for Read-Scale (clusterless) failover:
"If the primary replica is not available and can't immediately be recovered, then you need to force a failover to the secondary ...
0
votes
0
answers
834
views
SQL Server - Statistics MetaData Deadlock
We have an Always On architecture of 4 servers.
2 servers are in availability mode synchronous commit. let's call them A and B.
and 2 servers are in availability mode asynchronous commit. let's call ...
0
votes
0
answers
578
views
Connection to Availability Group Listener gives a 'Transport Level' Error in SSMS when I shut down Primary
I have a Node1\INST1 SQL Server instance which is the Primary and a Node2\Inst2 which is the Secondary in the High Availability Group. Both shows 'Synchronized' as the status, and both show 'No Data ...
0
votes
1
answer
257
views
SQL Server 2019 Always On AG - DBEngine Service account locking
I am having a strange issue and am hoping you guys might be able to help!
Problem: I have a 2 node SQL Server 2019 Availability Group Cluster utilising a FSW. Both nodes are using the same DBEngine ...
0
votes
0
answers
70
views
Shared Schedules & Always On Availability
We are running a report server on a SQL 2019 Always on AG in MS Azure.
When you go to see the Shared Schedules in Reporting Services and SQL Server is on the secondary replica, RS cannot see these ...